Multiple Column Transpose with Rename

[Wixard]

Hi all,

I would like to convert a table that has this sample structure

	Blue	Red	Green	Blue1	Red1	Green1	Blue2	Red2	Green2
Attribute	1	2	3	10	20	30	100	200	300
Scale	4	5	6	40	50	60	400	500	600

into this

	Colour	Code	Price	Dimension
Attribute	Blue	1	10	100
Scale	Blue	4	40	400
Attribute	Red	2	20	200
Scale	Red	5	50	500
Attribute	Green	3	30	300
Scale	Green	6	60	600

The labels "Colour", "Code", "Price" and "Dimensions" are not actually in the first table, so would need to add that in within Alteryx designer.

What formula is needed in the RegEx tool to remove the 1 and 2 after the colour names in first table.

[Thableaus · Accepted solution]

Hi @Wixard 

Here's a workflow to solve your problem

Let me know if there are any questions.

Cheers,

[Wixard]

Had to build on what you sent to do a few more things I needed, but was exactly what I was looking for.

Thanks a lot for your help @Thableaus!!!