Displaying Lookup List; without Blank entries or Repitition and in Sorted Order

Hello Wizards!

Trying to build a Software Info, for my friend, I am using LIST of values from the "License" column of another Worksheet. There are Blank Rows; as well as; Repeated Entries, and the entries are Unordered.
I want the LIST without these anomalies. I hope to get help, as always.

Actually, there is another issue, as well, regarding the "Sub-categories" column. Here, I want to select an appropriate value from the same worksheet. But, if I am asking too much, then just ignore this point.

I have attached the Sample file for reference. Thanks in anticipation.

Regards.