To Filter Extracted Data in Columns
Click
Insert tab
Linking & Extraction panel
Extract Data
.
Find
In the Data Extraction wizard on the Refine Data page, right-click a column label and choose Filter Options.
Select a predefined filter from the drop-down list.
From the drop-down list on the left, select a value.
In the Filter Across These Values field, clear any values so that they are not included.
Related Concepts
Organize and Refine the Extracted Data
Related Reference
Commands for Data Extraction