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

Sample data.xlsx

binu_acs

@Meghnagupta one way of doing this

Tile_090124.yxmd