Hi, I want to split the column and join it. Basically reversing the crosstab. Any suggestions, please?
Prod ID | Period 1 | Period 2 | Period 3 |
2275 | 120 | 458 | 71 |
4548 | 144 | 56 | 29 |
11443 | 126 | 47 | 34 |
12019 | 55 | 899 | 65 |
12218 | 34 | 64 | 41 |
Prod ID | Period1 | Qty |
2275 | Period1 | 120 |
4548 | Period1 | 144 |
11443 | Period1 | 126 |
12019 | Period1 | 55 |
12218 | Period1 | 34 |
2275 | Period2 | 458 |
4548 | Period2 | 56 |
11443 | Period2 | 47 |
12019 | Period2 | 899 |
12218 | Period2 | 64 |
2275 | Period3 | 71 |
4548 | Period3 | 29 |
11443 | Period3 | 34 |
12019 | Period3 | 65 |
12218 | Period3 | 41 |
Solved! Go to Solution.
Hey @Kuha, to reverse a Cross-Tab, you just need to use the Transpose tool. In your case, just ensure you group by Prod ID: