Concatenating based on

[insomned]

I have a list of people with a description of their goals. Since they are also earning points, I need to use a summary tool, and before that would like to concatenate the goals based on the person's first name. 

Help would be much appreciated! Thanks!

[bensilv]

Hi @insomned, what do you mean by concatenate based on the person's first name? Could you share an example of what you would expect to see?

To concatenate in the formula tool, you would just need to use the + sign.

E.g. to concatenate "John" in [First Name] and "Smith" in [Last Name], it would simply be [First Name] + [Last Name]

[AngelosPachis]

Hi @insomned ,

Assuming that your input looks similar to this

You can use a summarize tool to group by the person's name, concatenate their goals and sum the points.

Hope that's what you're after.

Cheers,

Angelos

[atcodedog05]

Hi @insomned 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[insomned]

For example, 

Goals Person

X          John

Y          John

Z          Mary

I would need to have a column with X, Y for John, and so on.

[atcodedog05 · Accepted solution]

Hi @insomned 

Similar to @AngelosPachis suggested it would be like this.

Workflow:

Hope this helps : )

[insomned]

Super helpful, thanks everyone!

[atcodedog05]

Happy to help : ) @insomned 

Cheers and have a nice day!

[insomned]

Thanks, and have a nice day You too!!