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!
Solved! Go to Solution.
See attached example, I used a formula tool to concatenate project and property, then a summarize to concatenate the rows.
That works perfectly @Luke_C ! Thank you so much for your help. And you too @atcodedog05 ! You guys are awesome!