Sort excel sheet data content


I have an excel sheet. I want to fetch data from a column item_ID and sort it accordingly. Item_ID contains duplicate values. I need to fetch remaining data in excel sheet based on the item_ID. If the item_ID is same, create another sheet and add those rows of data into that sheet. Repeat it for all item_ID’s. Can anyone suggest me how can i do this please?


1 Like

If you have duplicates, you want to add it in the new sheet right? Then you have to loop through all the values you have.

You can read the excel data using activities, sort it based on the column as well and to remove duplicates we have activity available.

1 Like

Hi ,

Take a look it helps you.


1 Like