Forum Discussion
Help needed with unpivot Power Query Transform
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
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
Thanks, I've followed that step to get the below results but still cannot get the data in the format I need even after trying to do the pivot as suggested. Sorry, I feel really useless not being able to work this out (not used Pivot/Unpivot before)!
