CODEWITHSUNDEEP
excellistemail
user3347638
user3347638

Reputation: 36

How to combine multiple email lists in one Excel file?

I have about 40 email lists, for a total of 300.000 rows. They are not similarly formatted, as they have slightly different info (i.e. some have age, some don't), but they all have a column for the email addresses. I'm trying to combine them in a single document, keeping only the email addresses and removing duplicate emails.

Thank you for your help!

Upvotes: 1

Views: 45

Answers (1)

Pomodoro Technique Game
Pomodoro Technique Game

Reputation: 317

Have you considered to import all excel documents into database ? Then you can do SELECT DISTINCT UNION from database.

Upvotes: 1

Related Questions