Is it possible to find and get rid of duplicate rows easily?
Oct 26, 2015 7:18 AM(1270 views)
Olivia Lippincott shares a tip from Byron Wingerdfor an easy way to find and get rid of duplicate rows. Join the table to itself (Tables>Join), match all columns, drop multiples for the Main and With Tables, and then save the joined table with a new name. (Saving with a new name is most always better than renaming or changing in place because it allows you to examine the changes and assure they reflect what you really wanted to do.)