Need Help: How to merge duplicate contacts containing partial data into one entry in .csv

I have .csv files that contains all my contacts from both an exchange account and my iCloud account. Both accounts did not have the same data for the same person (example: the Exchange account may have had the address while the iCloud may have had the phone number). On the merged .csv file I now have the same contact showing on two rows.....one was the Exchange account and other is the data from the iCloud account. Since each row for the same contact only contains a portion of the data needed, I was hoping there was a way to combine the contacts data if their first and last names matched. Example...the file show 2 Joe Smiths, one row has his phone number and the other row has his address. Is there a way to move this all into one row in which I would have a single entry showing Joe Smith, his phone number, and address all in one row? I would rather not post the actual file with all my contacts data but I have attached a file to show what I am trying to accomplish.

Any help would be greatly appreciate,

JoshExample of request.xlsx

Hi jayc2111,

Based on the excel sheet you provided use the following formula:

{=IFERROR(INDEX(F$4:F$5,MATCH(1,IF($B$4:$B$5=$B9,1,0)*IF($C$4:$C$5=$C9,1,0)*IF($D$4:$D$5=$D9,1,0)*IF(ISTEXT(F$4:F$5),1,0),0)),"")}

It is an array formula so you have to use CTR+SHIFT+ENTER after inputting it in the cell, otherwise you'll get " " based on the iserror function at the start.

Also for some reason "Joe" in B5 is different to "Joe" in B4 & B9, which will stuff up the If statement. If functions can only match exact text so you may have a space at the end

Let me know how you go.

Cheers,

Forgot to mention input formula into F9 and because it is an array formula drag the cell to the end, can't copy and paste