Forum Discussion

peterlyngvig's avatar
peterlyngvig
Regular Visitor
2 years ago
Solved

Transpose rows to columns

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

 

 

 

3 Replies