Finding Blanks based on matching fields in my Salesforce Input Data

[sailesh_doraiswamy]

Hello,

I'm trying to filter my Salesforce contact records based on whether the preferred email that they have listed is blank. So for example, if a contact lists their personal email as a preferred email, I want it to filter only records where the personal email is blank. Also, I'd want to grab one of the listed emails if the "Email" field is blank. So for example, I'd want to see records in which the "Email" field is blank, but at least one of the email fields (Personal Email, Alternate Email, etc) is populated. Are either of these scenarios possible? If so, how would I go about these? 

[Qiu]

@sailesh_doraiswamy 

I would say it is possible.
We use the Transpose tool to bring the all email fields to vertical and flag them for blank or not.

better to have some sample input and output though. 😁