Fetching duplicate values from specific column and coping it to another excel sheet

[ceyda_eren]

If the Remove duplicate activity is not enough, you can also follow this process.

Find the duplicate rows based on one column name and move to a different Datatable

Hi Team, Need help in the below scenario. I have gone through all the help topics and could find an exact solution for the scenario. My scenario is, I need to find the duplicate rows in the main datatable based on the “Subject” column and the keeping the 1st occurrences and other non-duplicates in the main datatable and move all the duplicates to another new datatable. Main Datatable: [image] New Duplicate Datatable should look like this: [image] So once we moved the duplicate to the new …