Hi,
I have a data like below ..
Date | country | Amt_1 | Amt_2 |
2022-07-01 | UK | 1000 | 2000 |
2022-07-01 | US | 3000 | 2000 |
2022-07-02 | UK | 500 | 600 |
2022-07-02 | US | 4000 | 500 |
I need the output like this. How can we achieve this?.
Date | UK_Amt_1 | US_Amt_1 | UK_Amt_2 | US_Amt_2 | |
2022-07-01 | 1000 | 3000 | 2000 | 2000 | |
2022-07-02 | 500 | 4000 | 600 | 500 | |
Solved! Go to Solution.
Hey @arkimp, how's this? The workflow just Transposes the data and brings the country as well as original header into the data, so that they can be combined into the new header before being Cross-Tabbed back to the format you'd like: