Of a table with E-mails, take all values assigned to one E-mail and concatenate them

[FernandoSantello]

Hello, first of all, thank you for taking your time to read my problem.

With that said, I have a table that looks like this:

(The Help column is just something I created because it could be useful to what I'm trying, but it doesnt need to exist).

What I want to do is take each E-mail on the "E-mail" column and all projects and properties assigned to it on the "Project" and "Property" columns. For example, "one@gmail" has Project 1 Property 2 (first line) and Project 2 Property 1 (second line). So one@ gmail has 1,2 ; 2,1 assigned to it.

My expected result is this:

So far I've been trying without sucess. I'll keep at it, but if someone could show me how to do it or shed some light into my problem, I would really appreciate it.

Thanks again for your time!

[atcodedog05]

Hi @FernandoSantello 

Can you provide sample data as excel. We can help you out.

[FernandoSantello]

Sure thing! Sheet 1 its my initial data, and Sheet 2 its the expected Result.

[Luke_C · Accepted solution]

Hi @FernandoSantello 

See attached example, I used a formula tool to concatenate project and property, then a summarize to concatenate the rows.

[atcodedog05]

Hi @FernandoSantello 

My approach would be similar to @Luke_C  🙂

[FernandoSantello]

That works perfectly @Luke_C ! Thank you so much for your help. And you too @atcodedog05 ! You guys are awesome!