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!