Stack Multiple Value columns but maintain column name in new field

[jbassin]

I am trying to stack my data by each value field while maintaining the column name they came from within a new field.

See illustrative example below:

Before:

Classification 1	Classification 2	Classification 3	Value 1	Value 2
A	1	2b	1	10
A	1	2b	2	20
B	2	2b	3	30
A	2	2d	4	30
A	2	2d	5	30
A	2	2d	6	30

After:

Classification 1	Classification 2	Classification 3	Value Category	Value
A	1	2b	Value 1	1
A	1	2b	Value 1	2
B	2	2b	Value 1	3
A	2	2d	Value 1	4
A	2	2d	Value 1	5
A	2	2d	Value 1	6
A	1	2b	Value 2	10
A	1	2b	Value 2	20
B	2	2b	Value 2	30
A	2	2d	Value 2	30
A	2	2d	Value 2	30
A	2	2d	Value 2	30

Any help would be greatly appreciated.

Thank you!

[atcodedog05 · Accepted solution]

Hi @jbassin 

Here is how you can do it.

Workflow:

Hope this helps : )

[jbassin]

Thank you so much for the quick reply! This is exactly what I needed. My configuration of the transpose function was off but this was what I needed.

[atcodedog05]

Happy to help : ) @jbassin 

Cheers and have a nice day!