Transposing a groups of columns

[Javier070590]

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

[Luke_C]

Hi @Javier070590 

The solutions to this post should help you. Working with multiple headers is tricky but not impossible!

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Transpose-multiple-headers-to-r...

[Maskell_Rascal · Accepted solution]

Hi @Javier070590 

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

[Javier070590]

@Maskell_Rascal Thank you! Works perfectly.

@Luke_C thank you also for your time and reply.

Best regards,

Javier