Consolidating columns from wide to long format

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!

Tips and Tricks

Accepted answers

kat

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 magic

Cheers

Katrin

transpose.yxmd

All comments

kat

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 magic

Cheers

Katrin

transpose.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703