Concatenate , email

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

Accepted answers

JosephSerpis

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.

Concatenate_3009302022.yxmd

All comments

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

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.

Concatenate_3009302022.yxmd

Anthony_white

Awesome, thank you for your help!

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335