Division of data in excel

Hi,

how I could division of data in excel/csv in simple way. Below details:
my output csv has e.g. two columns:
Name and Value
Tom 100
Allan 500
George 40
Tom 35
Brian 20
Allan 100
I would like to create new excel/csv for each name:
First excel has data:
Tom 100
Tom 35
Next
Allan 500
Allan 100
etc.

If it is possible please do example in uipath.

You will need to first get a distinct list of names, you can then use a for each to get all rows with that name by filtering the datatable, once you have that you can write that to an excel file and carry on with the rest.

1 Like