Data Prep extract for all nulls

Altair Community Member
Updated by Janet_21505
Maybe this is an enhancement request? I have 24 columns of data that I would like to extract the rows based on all columns being null for that record. Tried using Extract Rows, but finally realized I can't use this feature to get the result I am looking for. If there was an option to "INCLUDE all rows where ALL key columns contain:" I would be set. Otherwise, I have to work with more logic over X number of columns which is a pain.
In the screen shot I would want to result to give me Port# 109,111,114, 117, etc.

------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
5403490215
------------------------------