Hello,

I have a list of clients, emails, domains. And for every domain the client
has there is a row in the spreadsheet:

Some One, , someone1.com
Some One, , someone2.com
Some One, , someone3.com
Some Other, , someother.com
Some Thing, , something.com
Some Thing, , something1.com

I would like to combine the domains for the same clients using some
delimiter (;)

Thank you.

in column d row 2 check if 2 consecutive e-mails are the same, if they
are, concatenate c1 with c2 (in d1 put c1 to get you started).

Then if you get a third identical e-mail, it will concatenate c3 with
"the concatenated c1 and c2".

does that help?


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=568959

you need to concatenate d1 and c2, and you need to put in d2 c2 if the emails
are not the same, and some way to delete the unuseful ones

However the idea helped a lot! Thanks

Using robert111 advice, you could create a helper column that places a Y in
it if the domain is the same as the previous. To remove the duplicates, you
could filter for Y and delete.

"dimitar.peev" wrote:

you need to concatenate d1 and c2, and you need to put in d2 c2 if the emails
are not the same, and some way to delete the unuseful ones

However the idea helped a lot! Thanks

Very helpfull thank you both!

Your welcome. Glad to help. Thanks for the feedback.

"dimitar.peev" wrote:

Very helpfull thank you both!