Forum Discussion
Solved
Transpose data
Hi, I am constantly have to transpose several combined data from rows to columns, would anyone share with me a way to automate this step? I include the original file, and the file I have done ma...
Hi ale259 ,
Thank you for your inputs Cookistador FreemanZ Deku .
The Unpivot Columns feature in Power Query is indeed the most suitable approach for this transformation.
1️. Select the first column (Time) and unpivot the remaining columns using Transform → Unpivot Columns in Power Query.
2️. This will restructure the table into a City | Time | Value format.
3️. If necessary, rename the columns for clarity and sort by city name for better organization.FYI:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
