Forum Discussion
transpose
Hello, I want to know how I can transpose this data from columns to rows. I have lot of columns like that but just for example sharing an example, Name Plan index Project Name Schedule...
HI Anonymous
Please go in Power Query and select the first five columns of your dataset using STRG so that all of them are selected.
Then use the "unpivot other columns" feature.
You can find more information under:
Unpivot columns - Power Query | Microsoft Learn
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hello Mike,
these columns are derived from other columns so they are not in power querry editor. Can something be done in outside of power query editor?