Combining cells for repeated content/values

[Amy_Herman]

Hi!

Hoping someone has done this before.

I have a list of customers and their email addresses organized into groups. So I have 3 columns: customer name, email, and group #. I’m looking to make a new table for email automation. I’d like to pull all emails associated with a single group number into a CSV field called “recipients.”

Is this possible? I’d appreciate some guidance if so. Alternate workflows welcome.

Thanks!

[Kamille_Parks]

This thread is 3 years old, that demo base is long since deleted.

This is a textbook example of when to use a lookup field. Based on the description of the original problem, all I likely did was make a table for Groups, linked each Customer to the appropriate group with a Link to Record field, and in the Groups table add a loop field. Review Airtable's documentation: 

https://support.airtable.com/docs/lookup-field-overview