I want to remove duplicate names, but fill incomplete information into one complete row. For example

Column A
First Name

Column B
Last Name

Column C
Address

Column D
Phone Number

My cells have something like:

John Doe 1234 S Chicago
John Doe 333-333-3333

I want one row to say

John Doe 1234 S Chicago 333-333-3333


I have a large set of data with duplicate persons, but with missing information from their rows. I want to merge it all into one complete row. Any ideas?

Thanks!

Dan