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 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.