Extracting Nulls and Blanks

To extract empty rows or rows with empty values in a table, select Transform… to launch the Transform dialog and then click Extract Nulls and Blanks. You can:

q  Exclude all empty rows

q  Exclude rows where there is an empty value in any column

q  Include rows where there is an empty value in any column