Split data from rows to column after a particular cell

[Meghnagupta]

Quick question on dummy data below. I want to split data after Country "Belgium" and want required mentioned output data every month.

Is it possible in Alteryx if someone can help me out over this. 

Input data:

Report Date	Continent	Country	Foreign Holdings	Foreign US Purchases
12/29/2023	Europe	Belgium	0	0
12/29/2023	Canada	Canada	0	0
12/29/2023	Asia	Total Asia	0	0
12/29/2023	Africa	Total Africa	0	0
12/29/2023	Other Countries	Marshall Islands	0	0
12/29/2023	International and Regional	Depository Institutions	0	0
12/29/2023	Europe	Belgium	1	1
12/29/2023	Canada	Canada	1	1
12/29/2023	Asia	Total Asia	1	1
12/29/2023	Africa	Total Africa	1	1
12/29/2023	Other Countries	Marshall Islands	1	1
12/29/2023	International and Regional	Depository Institutions	1	1
12/29/2023	Europe	Belgium	2	2
12/29/2023	Canada	Canada	2	2
12/29/2023	Asia	Total Asia	2	2
12/29/2023	Africa	Total Africa	2	2
12/29/2023	Other Countries	Marshall Islands	2	2
12/29/2023	International and Regional	Depository Institutions	2	2

Output data:

Report Date	Continent	Country	Foreign Holdings	Foreign US Purchases	Foreign Holdings	Foreign US Purchases	Foreign Holdings	Foreign US Purchases
12/29/2023	Europe	Belgium	0	0	1	1	2	2
12/29/2023	Canada	Canada	0	0	1	1	2	2
12/29/2023	Asia	Total Asia	0	0	1	1	2	2
12/29/2023	Africa	Total Africa	0	0	1	1	2	2
12/29/2023	Other Countries	Marshall Islands	0	0	1	1	2	2
12/29/2023	International and Regional	Depository Institutions	0	0	1	1	2	2

[cjaneczko]

The above workflow will work you'll just need to make a branch with a Crosstab for each Column in your Data set. You'll need 8 crosstabs and then change the Join to a Multi Join. You could probably batch macro it if you have more columns than the sample dataset. 

Foreign US Sales

Foreign Valuation due to Price

All Other Holdings

All Other Purchases

All Other US Sales

All Other valuation Due to Price

[Meghnagupta]

@cjaneczko I am attaching workflow which i have created.

This will sum up all the values which I don't want. If you can help further on this.

[AndrewDMerrill]

Here is an alternative sample that should work better with multiple columns: