Excel users frequently want to remove rows that have duplicate values. For example to remove the rows with duplicate emails in:
This is trivially easy to do in Easy Data Transform:
In the right pane check the columns you want to remove duplicates for. Only the first row with a particular value is kept.
Note that duplicate checking is sensitive to case and white space. You can use Case and Whitespace transforms before the Dedupe to modify case and whitespace, e.g. to set all the emails to lower case. You can also use the Sort transform to change the row order before the Dedupe.
When you are happy with the results output the result into a new Excel spreadsheet or CSV file.
Easy Data Transform allows you to combine 45 different transforms to quickly and easily manipulate your data. You can also use it to show duplicates in Excel.
v1.8.2 for Windows 10 / 8 / 7 (49 MB)
v1.8.2 for Mac 10.15 to 10.12 (23 MB)
Questions or problems?