Need help in creating workflow/macro

[jatienza]

Hi guys,

Need help in creating a workflow or macro for the data below. The objective is just to get which among the RecordIDs have empty email in all columns record_1_email, record_2_email, etc. The workflow should also work if there are additional fields like record_6_email, etc.

The output/result would be 1012 since is has empty email in all columns.

RecordID	record_1_email	record_2_email	record_3_email	record_4_email	record_5_email
1011	john.smith@yahoo.com
1012
1014			a.troy@gmail.com
1015		arthur.king@yahoo.com			s.truck@gmail.com

Thanks,

Jaime

[Felipe_Ribeir0 · Accepted solution]

Hi @jatienza 

Transposing the data will let you avoid the necessity of using a macro:

[flying008 · Accepted solution]

Hi, @jatienza 

Another lively solution for this: