How do I generate a drop down list that has no blanks in it? I used data
validation to pull the list names from another column. However, the column
has blanks in it. It would be great if there were a way I could delete the
blanks in the drop down list and sort it by alpha.