A couple of months ago I was creating a database with about 4,000 contacts. I imported these contacts through about 40 different excel files for each individual event the guests attended. Consequently, I have duplicate guests in my database that have been given different ID numbers, which which I don't want to delete. I want to sort these guests through their emails, but I don't know how.
Thanks in advance.
I have also attached a very basic and watered down version of what I so far have of the database without any private information to just give an idea.