I have database of thousands of records, there have been some errors in multiple previous uploads resulting in mass duplication of hundreds of records.
I understand you can find duplicate records by going through each record one at a time, but this will take me far too long. Is there a way instead to find all duplications at once according to for example email address, and merge the duplicate records into one record for each email address?
Anybody know if this is possible?
Best
Scott