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

[Anonymous]

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

[Fowmy · Accepted solution]

@Anonymous 

Please check the attached file below my signature and let me know if it works as expected.

[Fowmy · Accepted solution]

@Anonymous 

Please check the attached file below my signature and let me know if it works as expected.

[Anonymous · Accepted solution]

@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