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 set what you want to do with each column. You should set at least 1 column to Keep unique.
Note that duplicate checking is sensitive to case and whitespace. You can use Case and Whitespace transforms before the Unique 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 Unique.
The Unique transform is very powerful. For example, you can do the following:
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 52 different transforms to quickly and easily manipulate your data. You can also use it to show duplicates in Excel.
v1.18.0 for Windows 10 / 8 / 7 (36 MB)
v1.18.0 for Mac 11.x to 10.13 (36 MB)
Questions or problems?