Microsoft Office Forums - View Single Post - Transform Repeating Rows into Column Headings

Alansidman · 11-21-2023, 07:15 PM

With Power Query/Get and Transform Data

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date Enrolled", type date}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Course]), "Course", "Date Enrolled")
in
    #"Pivoted Column"