Flip data by 90 degrees

Hello Everyone,

I'm trying to "flip" a table by 90 degrees (see attached workflow).
I was browsing threads here, and tried using Transpose, then Cross Tab in combination with Tex to Columns (rows), but somehow it didn't get the result I need; also, using as many Text to Columns as values is often not feasible with the datasets I'm working with.

How can I get from the first to the second table as shown in the workflow?

Best,
Szabolcs

HowToFlip.yxmd

Transformation

Accepted answers

LordNeilLord

Here we go

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

HowToFlip.yxmd

All comments

LordNeilLord

HI @szabolcsf

You were almost there, you just needed a way to group the values so they didn't end up in one row, I parsed out the number in the original header to do this:

HowToFlip.yxmd

szabolcsf

Hi @LordNeilLord,

Thanks, that looks exactly what I'm looking for!
Unfortunately I don't have the latest alteryx version and can't update yet - could you show a screenshot of the RegEx tool you've used?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703