How to delete duplicates and merge data using a macro

I have merged two different databases worth of information. There are now many duplicates within the database. The probelm is that one database had half the information while the other database had the other half of the information I need. What I would like to do is merge the two databases worth of information and delete the duplicates.

Example:
New Database
Name Type Interest1 Interest2
John Smith GP Sports Orthopedics
John Smith Respitory


What I want:
New Database
John Smith GP Sports Orthopedics Respitory

If anybody could help me out it would be greatly appreciated. I can provide you with any additional information.

Thanks,
LIz