Remove duplicates from table using database of 1200 rows.

[ebirdbook]

Hi, Is there a way to remove duplicates from a table where there are many repeats, there are probably 20-30 items so i could create them manually if this is too much of a struggle?