Rather than using a table as your lookup, use a View that filters out the blank entries. Refer instructions to filter the table by using a View as mentioned in this article View to filter a Table. Use Comparison type “Is Not Blank” for the field that has the blanks.
Click here to load this Caspio Online Database.