Consolidate rows if they match a specific column

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.

Try this:-
Results start "H1"

Please Login or Register  to view this content.

Regards Mick

Hello Mick

Thank you very much for the code.

Unfortunately, am not an advanced user of Excel, how would I go about implementing the code?

Thank you once again for your assistance.

Try this:-
To Save and Run Code:-
Copy code from Thread
In Your Data sheet , Click "Alt+F11",:- Vb Window appears.
From the VBWindow toolbar, Click "Insert" ,"Module":- New VBwindow appears .
Paste Code into this window.
Close Vbwindow.

On sheet Click "Developer tab", Click "Macro". Macro dialog box appears.
Select Macro (with same name) from List.
On the right of Dialog box Click "Run"
The Sheet should now be updated.
Regrds Mick

PS:- If you want to save results to new sheet, change the line at bottom of code From:-
With Range("H1")
to
With sheets("Sheet2").range("A1")

(Change sheet name to suit)

Thank you very much.

The code works like a charm on the data.

Thank you very much.