Transpose rows to columns

[peterlyngvig]

Hi

My input is in the form pictured in picture 1 below. Now, I would like to convert that to something like picture 2, in order to be able to calculate sales and EBITDA growth. What is the most efficient way to do this?

I have used the "Transpose" function, but seems I can only do that with one variable at a time - i.e. either sales or EBITDA. So, in principle I could do this twice and then merge the two queries, but that would take a long time to load, and intuitively seems inefficient.

Hope someone would be able to help.

Picture 1 - Input

Picture 2: Desired output

[Ahmedx]

I optimized the solution, try this variant

[peterlyngvig · Accepted solution]

Thanks!

[Ahmedx]

this requires a lot of work, but I have done it for you, please study everything, please do not submit additional requirements here