Forum Discussion

ale259's avatar
ale259
Helper I
1 year ago
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...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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.

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi ale259 ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.