Consolidating columns from wide to long format

[drewh]

Hello Alteryx experts - hoping you can help solve my problem.

My data looks like this:

And to make it user friendly for Tableau, I need to consolidate the Groups into one column, while separating out their percentages in another. 

The ideal output would be:

Any help is greatly appreciated!

[kat · Accepted solution]

Hi @drewh

I remember when I started using Tableau, didn't have Alteryx and had to do this in Excel.. painful!! Luckily you have Alteryx and it's one tool solution! The magical transpose!

magic

Cheers

Katrin

[Ladarthure]

Hi, 

to do this, just use a Transpose tool (in summarize category), it should do the job.

Hope it helped!

[drewh]

Well that was simple enough, thank you Katrin, appreciate the quick advice for a newbie!