Multiple rows, duplicate entries, mail merge

[RHicks]

Having an issue where I am trying to use mail merge in congress with an Excel spreadsheet. The spreadsheet in question has a data dump from the database and lists mutiple rows of contact information. However some of the contacts have multiple Job descriptions, hence there are duplicate rows for some of these people. I am trying to find a way to combine the data from the multiple rows of these duplicates into one row so that mail merge will pull the data from it correctly. If that was as confusing as it feels, let me try an example.

In the attached spreadsheet example, I need mail merge to pull from one row, all of Mr. Pink's information. You will notice that he exists in the list three times, because the industry column is unique for each row. What I would like to do is somehow combine this information into a single row for Mr. Pink, and as many others as are represented in the data dump, so that mail merge will work.

Many thanks for any assistance,
RB