Forum Discussion
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
I optimized the solution, try this variant
Thanks!
3 Replies
- AhmedxSuper User
this requires a lot of work, but I have done it for you, please study everything, please do not submit additional requirements here
- AhmedxSuper User
- peterlyngvigRegular Visitor
Thanks!