Forum Discussion
Solved
Help needed with unpivot Power Query Transform
I've attached a screenshot which I think explains everything. I have a data table (green) which I need to transpose/unpivot using power query (Get & Transfrom) so that I get the table seen below (blu...
Check your column "OrderID"
Unpivot others
Split your column "Attribute" by space at the rightmost delimiter
Check column "Attribute.2"
Replace null by Amount
Pivot on this column
Thanks, I got it to work using your 'Split Columns' and using a value of 3 instead of 14, and then continuing from there. Much appreciated.
Sorry, yes - the changed split-operation meant that a blank space has sneaked in. So the other solution would have been to Trim the Attribute.1-column before pivoting.