Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query - How to transform data with Pivot function for multiple columns

Hi,

 

I would like to perform a data transformation in Power Query with the pivot function.

Below is an example of what I want to achieve.

 

ORIGINAL DATA

 

FINAL DATA I WANT TO GET

 

column3 = unique key that I want to retain in the table without duplicates

column4 = attribute column that I want to "pivot" from rows into several new columns as header

column 5 & 6 = value column from the original unpivoted column and distributed as values to the corresponding new columns

 

I have already tested the pivot function in Power Query but that seems not work with multiple value columns (column 5 & 6).

Anyone can suggest how to achieve the above result in Power Query?

Thanks!

 

Best regards,

Emily

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Fowmy Many thanks for sharing the sample solution file!

    I've tested it in my real business report and fine-tune some of the M codings based on business requirement, it works well with the expected result.

    Thank you so much for your quick reply and have a great day!

     

    Best regards,

    Emily

2 Replies

Replies have been turned off for this discussion
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Fowmy Many thanks for sharing the sample solution file!

      I've tested it in my real business report and fine-tune some of the M codings based on business requirement, it works well with the expected result.

      Thank you so much for your quick reply and have a great day!

       

      Best regards,

      Emily