Forum Discussion

ebp2022's avatar
ebp2022
Frequent Visitor
2 years ago
Solved

Transposing Schedules From Column to Rows

Hi, I've tried a couple of pivoting approaches but I can't seem to get the desired outcome.   I would like to transpose the data from the left to the right using Power Query. Note that the columns ...
Need Help
  • Nithinr's avatar
    Nithinr
    2 years ago

     

    Click on ID, NAME in power query editor and right click --> unpivot other columns. so even though your other columns are dynamic it can pickup

     

    let
Source = your source ,
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"ID", "Name"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Date"}, {"Value", "Schedule"}})
in
#"Renamed Columns"

    ebp2022  

Nithinr's avatar
Nithinr
Resolver III
2 years ago

 

Click on ID, NAME in power query editor and right click --> unpivot other columns. so even though your other columns are dynamic it can pickup

 

let
Source = your source ,
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"ID", "Name"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Date"}, {"Value", "Schedule"}})
in
#"Renamed Columns"

ebp2022  

ebp2022's avatar
ebp2022
Frequent Visitor
2 years ago

This worked, thank you!