Merge duplicate cells in a column, while retaining information in other columns?

Is this just a one-time conversion you need to do? If so, follow these steps:

Create another worksheet (let's call it Sheet2)
On Sheet1 select column B.
Go to Data, SOrt & Filter, Advanced.
Select "Copy to another location"
Select Unique Records Only.
Click on Copy To and select cell I1
Click OK
Select column I
Cut (or CTRL+x)
Select Sheet2 column B
Paste (or CTRL+V)
In C2 enter this formula:

Formula:

Please Login or Register  to view this content.

then copy down for all rows of data
Copy headings from Sheet1!D:G to Sheet2!D:G
In D2 enter this formula:

Formula:

Please Login or Register  to view this content.

Copy to E2:G2, then copy D2:G2 down for all rows of data

I have attached a file where I did these steps.

To finish, select Sheet2!C:G, Copy, then Paste Values to convert formulas to values.