Data Split by Column Values

[Rashmigangadhara]

Hi ,

I`m looking for the dynamic filtering of the data set by one of the column values present in that data.

Eg : In the below data set I have data by Region, I need to split this data by region dynamically , and need that divided data sets for further analysis.

 Input Data

Unique ID	CoCd	Tower Name	Team Name	Region
100	10	TowerA	Finance	Region1
200	20	TowerA	Finance	Region1
300	30	TowerB	Procurement	Region2
400	40	TowerC	Finance	Region2
500	50	TowerD	HR	Region3
600	60	TowerA	Supplychain	Region3
700	70	TowerB	Supplychain	Region4
800	80	TowerC	Finance	Region4

Expected output :

Unique ID	CoCd	Tower Name	Team Name	Region
100	10	TowerA	Finance	Region1
200	20	TowerA	Finance	Region1

Unique ID	CoCd	Tower Name	Team Name	Region
300	30	TowerB	Procurement	Region2
400	40	TowerC	Finance	Region2

Unique ID	CoCd	Tower Name	Team Name	Region
500	50	TowerD	HR	Region3
600	60	TowerA	Supplychain	Region3

Unique ID	CoCd	Tower Name	Team Name	Region
700	70	TowerB	Supplychain	Region4
800	80	TowerC	Finance	Region4

With the current options, I will have to add the filters manually based on the number of regions , I want solution where I can replace this manual filter addition and even if more regions added in data that should be taken care dynamically.

Thanks

[binuacs]

@Rashmigangadhara you can write the regions in the same excel file with different sheets using the output tool