How do I make a drop down box of a list in a way that would remove all blank
fields or at the very least move the blank fields to the bottom of the list.
I have a list of names that become visible in the defined list after certain
conditions are met. As the conditions change different names become visable
and others become blank. I want the drop down box for this list to exclude
the blank names.