Power query transform combined files

[JFGC08]

Hello,

How can I tranform the left table in to the right table by using power query?

[mussaenda · Accepted solution]

Hi @JFGC08 ,

[JFGC08]

It worked!! Many thanks.

[JFGC08]

Hi ImKeF,

Many thanks for your feedback. I tested but only worked when aggregate value function is selected different than "Do not aggregate" otherwise it return error.

[ImkeF]

Hi @JFGC08 ,
I have described a method for it in this article: 
Pivot multiple measures and columns in Power Query (thebiccountant.com)