Best way to combine email addresses from multiple fields into one

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

Workflow

Output

Accepted answers

grazitti_sapna

Hi @orinocoworkflow, will this work?

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

Thanks!

All comments

grazitti_sapna

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.

0531-orinocoworkflow.yxmd

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703