How to concatenate grouped by field?

[richleeb2]

I want to send emails to everyone in the same group, the messages are the same for each group.

This is my current data:

Contact	Group	Message
john@abc.com	A	abc
kelly@abc.com	B	abc
pam@abc.com	A	abc
steve@abc.com	B	abc
jim@abc.com	A	abc

This is the output I want:

Contact	Group	Message
john@abc.com, pam@abc.com, jim@abc.com	A	abc
kelly@abc.com, steve@abc.com	B	abc

[FinnCharlton · Accepted solution]

Hi @richleeb2 , you can do this with the Summarise tool:

[richleeb2]

Thank you, does the MAX just ignore if the message is the same?

[FinnCharlton]

@richleeb2 Yep, it doesn't make any difference if they're all the same