Forum Discussion

ochaoui's avatar
ochaoui
Frequent Visitor
5 years ago
Solved

Column values as header : how to transpose the table

Hi folks,   I have a table like this coming from a json : app name name value A description XXXX A display name YYYY A note ZZZZ B description QQQQ B display name SSS...
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    ochaoui 
    For detail, select the name column=>pivot column=>select value as values column=>choose don't aggregate.

     

     


    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

     

Jagen007's avatar
Jagen007
Regular Visitor
2 years ago

Greeting,

This is my table design is as below.

Order No.MaterialDelivery no.
ABC-11245678400000000
ABC-12245678500000000
ABC-13245678600000000

 

My desired output is in this table format.

Order No.MaterialDelivery no.Delivery no.Delivery no.
ABC-11245678400000000500000000600000000

 

Kindly please help to advise how to solve this in Power Query or Power BI.