Combining multiple rows of data into one row

I am attempting to combine several contact databases and have run into a lot of duplicates. Some rows have more info than others for the same contact. Is there a way to combine duplicate rows based on first and last name into one row and then delete the source rows. Leaving one row with all the information. Or combine all the information into one row and delete the other row. Any help would be greatly appreciated.

Example.xlsx