Forum Discussion
Solved
Way to transform data from a pivoted like format into a more structured format
Hello, I am trying to figure out a way to use power query to transform a table of data into another. See pic below. I am trying to turn the table on the left into the table on the right. I was ha...
1- Remove "Total" Column.
2- Right mouse click on Type column and select "Unpivot Other Columns".
3- Replace "Tray" With Empty String on "Attribute" Column.
Unpivot StepAll steps:
All steps
baghdadi62
Resolver III
Resolver III1- Remove "Total" Column.
2- Right mouse click on Type column and select "Unpivot Other Columns".
3- Replace "Tray" With Empty String on "Attribute" Column.
Unpivot Step
All steps:
All steps
Thank you!!!