Transposing Columns

[dhakim1996]

Hi,

Does anyone know how to convert the following table:

Name	Cat 1	Cat 2	Cat 3	Cat 4
A	1	2	3	4
B	5	6	7	8

into this:

Name	Cat	Amount
A	Cat 1	1
A	Cat 2	2
A	Cat 3	3
A	Cat 4	4
B	Cat 1	5
B	Cat 2	6
B	Cat 3	7
B	Cat 4	8

Thank you in advance!

[DataNath · Accepted solution]

@dhakim1996 if you use a transpose tool and select Name as a Key Column that should do the trick. By default, Alteryx will name your transposed fields as ‘Name’ and ‘Value’ - as you already have a ‘Name’ column this second one will become ‘Name2’ and so you’ll need to use a Select tool or something afterwards to rename your columns as you wish.

Transpose like so:

Select after for rename:

[binuacs]

@dhakim1996 as @DataNath mentioned you need to use the transpose tool to get the desired result