Please Look into the Image:
Here We have been filtering the two cases,like
1)In Report 1099 Type is not Equal to “Not a 1099 Vendor”.
2)Second filter is for removing Empty or Null values from Report.
Select Column name and filter the option as “is equal to” and give empty .
Then we will have output related omitting the Null values or Empty values from Report.