How to split data based on column

[SahadhKuruniyan]

Hi Team,

I need help to split data based on column A. My data looks like:

Country	Size	Code
Brazil	10	A
Brazil	23	B
India	11	C
India	23	D
Gemrany	15	E
Gemrany	53	F
UK	12	G
Brazil	32	H

I want to split data like below and do further calculation in workflow:

Country	Size	Code
UK	12	G

Country	Size	Code
Gemrany	15	E
Gemrany	53	F

Country	Size	Code
India	11	C
India	23	D

Country	Size	Code
Brazil	10	A
Brazil	23	B
Brazil	32	H

Can any one please help

[Jodie_sam]

Hi jdminton,

Thanks so much for the solution example. It worked absolutely brilliant and I got the files split by country like how I wanted.