To Filter Extracted Data in Columns

1. Click Insert tab Linking & Extraction panel Extract Data. Find
2. In the Data Extraction wizard on the Refine Data page, right-click a column label and choose Filter Options.
3. Select a predefined filter from the drop-down list.
4. From the drop-down list on the left, select a value.
5. In the Filter Across These Values field, clear any values so that they are not included.