Dear Colleagues,
Could you support me with multiple transposing columns? I have 3 users having 3 measures (split by 4 quarters)
My input looks like:
Output I would like to achieve would be:
Thank you in advance!
Martin
Solved! Go to Solution.
The solutions to this post should help you. Working with multiple headers is tricky but not impossible!
It all depends on how you're inputting the data from your data source. I took a crack at a sample workflow for you to try out.
I had to make some assumptions on how the data is incoming, but this should work for you.
Let me know if this works for your needs.
Thanks!
Phil
@Maskell_Rascal Thank you! Works perfectly.
@Luke_C thank you also for your time and reply.
Best regards,
Javier