Data Manipulation - turning column headers into row headers

[AboutBlank]

Hello everyone,

On paper a simple task but racking my brains - I essentially want to perform the following in Alteryx:

Shift the data from:

Entity	Reserve 1	Reserve 2	Reserve 3
A	7	0	2588
B	-18	60	9490
C	-58	556	2930
D	-70	0	3527
E	-68	1760	344

to

Entity	Reserve	Amount
A	Reserve 1	7
A	Reserve 2	0
A	Reserve 3	2588
B	Reserve 1	-18
B	Reserve 2	60
B	Reserve 3	9490

So easy in excel but struggling in Alteryx! All help greatly appreciated.

Thank you

[NicholasM · Accepted solution]

Hey @AboutBlank 

This could be done using the Transpose Tool. The Entity would be your Key Column, with Reserve 1 - 3 being Data Columns. 

See attached workflow for an example of the tool configuration. 

Best,

Nick Michels 

[grazitti_sapna · Accepted solution]

Hi @AboutBlank,

Here is the solution to your problem.

Thanks.

[AboutBlank]

Thank you so much for your help! This is spot on.