Assign a duplicated cell to multiple other cells

Hi guys,

I have a spreadsheet with repeated email contacts for various clients.

For Example:

Column A Column B
Institution email
Bank1 [email protected]
Bank2 [email protected]
Bank3 [email protected]
Bank4 [email protected]
Bank5 [email protected]
Bank6 [email protected]
Bank7 [email protected]
Bank8 [email protected]
Bank9 [email protected]
Bank10 [email protected]
Bank11 [email protected]
Bank12 [email protected]

and I would like to convert it to:

email Institutions
[email protected] Bank 1, Bank3, Bank5, Bank7, Bank8,
[email protected] Bank2, Bank4, Bank6, Bank9, Bank11
[email protected] Bank10, Bank12

Pivot Table does not help in this case as it only gives the count of institutions.

Any ideas and help ?

Thanks and Regards

Nick

Try this:-
Results start "D1"

Please Login or Register  to view this content.

Regards Mick

Hi Mick,

Thanks for getting back to me.

As my Excel understanding is very basic I don't know where and how to input the script you have written.

Can you please enlighten me ?

Thanks and Regards

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