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!
Solved! Go to Solution.
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.
Happy to help : ) @jbassin
Cheers and have a nice day!