Forum Discussion

ethanlsaul's avatar
ethanlsaul
Icon for Helper I rankHelper I
4 years ago
Solved

Pivot/Unpivot Data

Hello,   I have tried every combo of pivot, transpose, unpivot. I want my data to go from    Product Plant Qty 123 US10 100 123 US20 200 123 US30 111 456 US10 26 456 ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, ethanlsaul ;

    You could use pivot it.and the seting as follow:

    The final show:

     


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

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, ethanlsaul ;

You could use pivot it.and the seting as follow:

The final show:

 


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