Forum Discussion

Niels_83's avatar
Niels_83
Copper Contributor
Nov 15, 2025

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? 
BI & Data Analysis
community
excel
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 15, 2025
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
    SortIt

if I understood the logic correctly

Resources