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 ,

 

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.