Microsoft Office Forums - View Single Post - [Solved] Need function that transpose the rows data of a table automatically.

Alansidman · 07-07-2023, 06:55 PM

With Power Query

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"})
in
    #"Removed Columns"