I have a spreadsheet with names and phone numbers. I have another spreadsheet with similar- but not the same names and not in the same order- with email addresses.

I have pasted all info into one spreadsheet and alphabetised it- it looks a little like this now.... (joe bloggs being an example name)

joe bloggs telephone no
joe bloggs email

Is there a way i can easily merge these two rows keeping the name the same? Otherwise it will take FOREVER!!

Thanks in advance.