"Subset By" with a column that has empty values - how to ignore them?

[#1]

I need to subset a table by a column with categorical values. Some rows have that By Column empty.

When I'm subsetting - how to NOT get any table where that By Column is empty?

Excluding and\or hiding those rows doesn't help, and I don't want to delete those rows.

Any other way?

[#2 · Accepted solution]

The way I would do this is to go to the data table and select all rows that do not have missing values for the column in question,

and then in the Subset dialog box, specify to only use selected rows

[#3]

🤦

Of course!

Select where not empty, subset with selected rows, then again subset by...

Thanks!