Flip data by 90 degrees

[szabolcsf]

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

[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:

[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?

---

[LordNeilLord]

@szabolcsf What version are you using? I'll downgrade it for you.

[szabolcsf]

 Hey @LordNeilLord, that would be great, thanks!
I'm using alteryx designer 11.0.5.26351

[LordNeilLord · Accepted solution]

Here we go

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome