Combine simmilar rows

[dimitar.peev]

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, [email protected], someone1.com
Some One, [email protected], someone2.com
Some One, [email protected], someone3.com
Some Other, [email protected], someother.com
Some Thing, [email protected], something.com
Some Thing, [email protected], something1.com

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

Thank you.

 

[robert111]

in column d row 2 check if 2 consecutive e-mails are the same, if the
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 wit
"the concatenated c1 and c2".

does that help

 

[dimitar.peev]

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

 

[Wiley]

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]

Very helpfull thank you both!

 

[Wiley]

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