Forum Discussion

maracles's avatar
maracles
Resolver II
10 years ago
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...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    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

     

ImkeF's avatar
ImkeF
Community Champion
10 years ago

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

 

maracles's avatar
maracles
Resolver II
10 years ago