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

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

5) Pivot over the Attribute.3 column

 

 

6) After that you can delete the unwanted columns and obtain your result.

 

 

 

Let me know if it works.

 

#I'M Not An Expert#

maracles's avatar
maracles
Resolver II
10 years ago

Anonymous

Thank you very much for the effort and useful diagrams. I ahve tried following those steps but when I pivot the Attribute 2 column in the way you describe I don't get the table that you show afterwards, instead I get this:



Any ideas?

Thanks. 

  • maracles's avatar
    maracles
    Resolver II
    10 years ago

    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. 

    • ImkeF's avatar
      ImkeF
      Community Champion
      10 years ago

      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.