Consolidate rows if they match a specific column

[CC_deallist]

Hello all

I have an excel list with leads data in it and each deal may have more than one sub list.
Right now each sub lead is listed as a new row, but i would like to consolidate sub leads into one row.

I have attached an example of the data and the output am looking for.

Thank you for your assistance.