I want to send emails to everyone in the same group, the messages are the same for each group. This is my current data: ContactGroupMessagejohn@abc.comAabckelly@abc.comBabcpam@abc.comAabcsteve@abc.comB abcjim@abc.comA abc This is the output I want: ContactGroupMessagejohn@abc.com, pam@abc.com, jim@abc.comAabckelly@abc.com, steve@abc.comBabc

How to concatenate grouped by field?

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

This is my current data:

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

Datasets

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

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

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