Forum Discussion
Niels_83
Nov 15, 2025Copper Contributor
unpivot from columns to rows in power query
I want to transpose data from different columns to rows: from: to: any suggestions how to do so in power query?
SergeiBaklan
Nov 15, 2025Diamond Contributor
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
First = Table.SelectColumns(Source,{"Naam", "employee1", "share employee1"}),
Second = Table.SelectColumns(Source,{"Naam", "employee2", "share employee2"}),
names = {"Naam", "employee", "share employee"},
append = Table.RenameColumns( First, List.Zip( { Table.ColumnNames(First), names } ) ) &
Table.RenameColumns( Second, List.Zip( { Table.ColumnNames(Second), names } ) ),
SortIt = Table.Sort(append,{{"Naam", Order.Ascending}})
in
SortItif I understood the logic correctly