Concatenate , email

[Anthony_white]

I am trying to concatenate several email addresses to a single field to be used for an email output, but not all emails sent will have the same number of email contacts. How do I combine all contacts to a single field while accounting for blank fields?

Company Name	Primary email	Email 2	Email 3	Email 4
Awesome Co.	somedude@email.com	RandomPerson@email.com	Guy@email.com	fella@email.com
Ink, Inc.	hombre@email.com	friendperson@email.com

[JamesCharnley]

I can't mock this up right now but what you'll want to do is transpose, grouping by company name. And then in a summarize tool, group by company name and in string functions, concatenate value.

[JosephSerpis · Accepted solution]

Hi @Anthony_white I came up with a approach you will need to pivot your data then filter out the null values then concatenate the emails with a summarise tool.

[Anthony_white]

Awesome, thank you for your help!