Help with merging data

[vel]

I have 2 lists of e-mail addresses in escell. Some addresses in list one (in
column 1) are repeated in the 2nd list (in column 2). Is there a way I can
combine the two lists and by doing so automatically to delete the duplicate
records and just leaving one of each duplicate record available in the final
combined list?

 

[Max]

One quick n easy way

Do a manual copy n paste of the 2nd list below the 1st

Then run a uniques filter on the combined listing in the 1st col, viz.:

Select the entire 1st col
Click Data > Filter > Advanced Filter
(Answer "Yes" to the prompt)
Check "Copy to another location"
Copy to: C1 (say)
Check "Unique records only"
Click OK, and the uniques listing will appear in col C