Combine data from multiple rows into a single row

Hello All, 

I am working on creating a customer database, and need help combining multiple rows of information associated with the same person. The problem I am running into, is that I need to keep the data from each individual column separate as I merge them into the same row.   

This is the current layout of my excel sheet: 

For Example, I would like all of this data associated with the customer so be merged into something that looks like this:

The end goal of this task is to be able to conduct a mail merge using the data all complied into one row. Please let me know if there is a way to do this through an excel sheet that has about 800 different contact points. I have tried using the VBA function, but cannot get the formatting correct. If someone could help, I would greatly appreciate it!