Splitting data from rows to columns

arkimp

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

DataNath

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:

Crosstab country values.yxmd