Forum Discussion
Solved
Stack one column under another column
I need to stack one column under another existing column. I have read that it can be done by unpivoting, in here, however, I do not understand how this is done. Thank you
I would do this - from the link post, copy paste the code to your advanced editor and look at one step at a time and see how is data changing with each step.
That way you learn and understand too.
Regards
Hi marami21
In addition to vmakhija's suggestion, you could copy the sample data in this thread as Source in Power BI by entering data, then copy and paste the code from step 2 ->#"Changed Type".
You could find how to use "unpivot columns /pivot columns" below:
https://radacad.com/pivot-and-unpivot-with-power-bi
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.