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

Anonymous 

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

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