Split excel into Unique and Duplicate Rows


I have this excel data which I would want to be split into 3 excel sheets.

  1. Retrieve only the unique Invoice number and write it in an excel sheet.
  2. Retrieve the first row only based on duplicate Invoice number and write it in an excel sheet.
  3. Retrieve the other rows of duplicate Invoice number and write in an excel sheet.
    UIPath_Excel_Scratch (3).xlsx (9.9 KB)

Hope you can help!


Can you help please?

find starter help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (9.3 KB)

1 Like

Hi @ppr

Can you provide source for learning LINQ?


1 Like

Does not work!

Please provide always details on what is not working. Only with this feedback we can help you. Thanks

So in other words you don’t know how to do it?

we implemented sucessfully a lot of scenarios handling duplicates, groups, takinng uniques, taking first from group etc. And we got it working.

But from a feedback “is not working” we cannot derive what exactly is not working at your end. Also we do not know on what have you implemented so far.

For this we asked you on details. Fell free to share it with us, so we can better help you or manage it by your own. Thanks

1 Like

I think there is a duplicate thread regarding the same topic.

@Yudhisteer_Chintaram : I’ve added the solution, please mark the thread closed with a solution. I took your input sheet and cleaned it up.
@Others: Please do let me know if you have any inputs / comments on the solution provided, its always better to learn more.SplitExcel.zip (10.4 KB)