Forum Discussion

Jos13's avatar
Jos13
Helper III
6 years ago
Solved

Unpivot multiple columns

Hi Team, I have a table for order details. Data has columns for each product ordered in a single order. I want to unpivot this data so that I get individual columns for product, kg and quantity. I t...
  • v-juanli-msft's avatar
    6 years ago

    Hi Jos13 

    1. select 'date" and "customer", select "unpivot other columns",

    2.select 'Attribute" and split column

    3.select 'Attribute.1" and pivot

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.