Duplicates in my Key Field

I have a basic database, list of email addresses with associated names, companies, countries etc. I believed my ‘key’ field was my ‘email’ field and therefore wouldn’t allow duplicates. however, I have just noticed that I have many duplicates in both my ‘key’ column and my ‘email’ column and that they are 2 different columns. I have edited in my design to not allow duplicates, but it doesn’t seem to change. Any advice on how to remove the duplicates from my ‘email’ column and not allow them to be duplicated when inputting new lists? Thank you.

Hi Jane,

For this issue, would you mind to issue a support ticket through the “Need Help?” at the upper right corner of your database and provide the duplicated e-mails for us to refer to?