Assign a duplicated cell to multiple other cells

[Nikolas1988]

Hi guys,

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

For Example:

Column A Column B
Institution email
Bank1 abc@hotmail.com
Bank2 def@hotmail.com
Bank3 abc@hotmail.com
Bank4 def@hotmail.com
Bank5 abc@hotmail.com
Bank6 def@hotmail.com
Bank7 abc@hotmail.com
Bank8 abc@hotmail.com
Bank9 def@hotmail.com
Bank10 xyz@hotmail.com
Bank11 def@hotmail.com
Bank12 xyz@hotmail.com

and I would like to convert it to:

email Institutions
abc@hotmail.com Bank 1, Bank3, Bank5, Bank7, Bank8,
def@hotmail.com Bank2, Bank4, Bank6, Bank9, Bank11
xyz@hotmail.com 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

[MickG]

Try this:-
Results start "D1"

Please Login or Register  to view this content.

Regards Mick

[Nikolas1988]

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

[MickG]

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