Forum Discussion

chall069's avatar
chall069
Frequent Visitor
2 years ago
Solved

PowerQuery Unpivot Table

I am trying to unpivot data in power query. The data comes in this format. I am not able to fisgure out the best way to create the second table.   PI20.2 PI20.2 PI20.2 PI20.2 PI20.2 PI20.2 ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

  • chall069's avatar
    chall069
    Frequent Visitor
    2 years ago

    Thank you very much. This work!