Combine data from multiple rows into a single row

[DMM17]

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!  

[#2]

Hi,

It could be done by Power Query, attached is quick mockup

[#3]

Sergei, 

Thanks for your reply, I tried to do a Power Query, but could not figure out the necessary steps to complete the task. If you have any suggestions for basic Power Query use, I would greatly appreciate it!