Best way to combine email addresses from multiple fields into one

[orinocoworkflow]

Hi community,

I have a data set for different clients and projects. Each client has multiple projects where the project manager may be the same person, or a different person.

I would like to get an output where, for each unique project/client set, a field is made with all of the email addresses from the various project managers who worked on every workstream for that client's project. This seems like it should be simple but my brain is not computing...

Here is an example of my desired input/output data:

Would appreciate any help I can get!

Thank you

[grazitti_sapna · Accepted solution]

Hi @orinocoworkflow, will this work?

EDIT: @Qiu and @orinocoworkflow   for getting to the exact desired output

Thanks!

[Qiu]

@orinocoworkflow 
To add on @grazitti_sapna solution,

We need a unique tool to get only unique record as I can see the duplicated email is removed.

Then the seperator should be "\n" to have a new line for each email.

[orinocoworkflow]

@grazitti_sapna and  @Qiu - thank you both so much for your helpful replies. I haven't really used the Concatanate function very much at all and kind of forgot that it exists! 

Solved :)

[grazitti_sapna]

@orinocoworkflow  glad we could help 🙂

[alvin]

I have 34 emails when I concatenate it only capture the fist 8.

The  concat_email field now say this cell has greater than 256 character.

Is there a way to expand this limit?