let

    Source = Excel.CurrentWorkbook(){[ Name = "Table13" ]}[Content],

    Transform = Table.AddColumn (

        Source,

        "Records",

        each [

            a = Date.Year ( [ORDER DATE] ),

            b = Text.Proper ( [SALES REGION] ),

            c = Number.Round ( [SALES], 0 )

        ]

    ),

    ExpandedRecords = Table.ExpandRecordColumn (

        Transform,

        "Records",

        { "a", "b", "c" },

        { "Year", "ProperSalesRegion", "RoundedSales" }

    )

in

    ExpandedRecords