SUMMARIZE table without blanks

I would like to have all unique values from a column in order to use it as a dimension table. Here is how I do that: Yet, even though I'm excluding the blank ones I still have one blank. On to...