I have a file of email addresses that may contain blank email addresses in various columns. So from the data in the screenshot below, the result I am looking for would be
1@email.com,2@email.com,3@email.com,4@email.com
Basically I need the not null fields concatenated together separated by a comma. When there is only 1 field, I would only want the single email address.
Thanks in advance.
Solved! Go to Solution.
Hey @Jeff13, how does this look? We just set a RecordID so we have something to group by when concatenating, Transpose to get all of our emails in a single field, Filter out any null values and set a standard 'Email' [Name] field, then finish off by Cross-Tabbing with concatenating as our method of aggregation. Finally we just sort by RecordID to restore our original order:
WOW. Amazing. Thank you so much!!!