Delete Duplicate Rows?
Use the Remove Duplicates feature of Excel.
-
Select your data.
-
Click
Remove Duplicates
on the Data ribbon. -
Choose which columns to use as criteria for duplicate entries. In your case, it's one column, so just select the single column.
-
Click
OK
.