I have two contact lists that I need to combine and there are several duplicate contacts between the two lists. My challenge is that list #1 includes phone numbers, no email...and the 2nd list has emails but no phone numbers.
Can I somehow merge the lists and combine contacts that are dups, but that can include the phone #'s from list 1 and the emails from list 2?



Name CITY ST ZIP Email Phone
list 1 John Smith St Louis MO 63130 5558675309
list 1 Tom Selleck St Louis MO 63122 5555555555
list 2 Tom Selleck St Louis MO 63122 [email protected]