Forum Discussion
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 (blue). I'm pretty sure I need to use unpivot but can't get it to work quite how I need it to.
Thanks.
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
13 Replies
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 Imke for the response.
I've tried following the stps and have got as far as splitting the "Attribute" column which leaves me with the image below:
The rest of the steps don't seem to work though, I'm not sure how to replace 'Attribute 2' by Amount as there are no null values.
Thanks.Sorry, you need to split by length instead: 14
