Need help in creating workflow/macro

Question

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.

RecordIDrecord_1_emailrecord_2_emailrecord_3_emailrecord_4_emailrecord_5_email1011john.smith@yahoo.com    1012     1014  a.troy@gmail.com  1015 arthur.king@yahoo.com  s.truck@gmail.com

Thanks,

Jaime

Felipe_Ribeir0 · Accepted Answer

Hi @jatienza

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

flying008 · Accepted Answer

Hi, @jatienza

Another lively solution for this: