Kathy, you could use the ISBLANK function to determine if the value in that row is blank, and then use that as one of your sort criteria. For example, if your value is in column A1, then B1 would be: =ISBLANK(A1)

Now autofill that value down the whole column, and now you have either TRUE or FALSE in column B. You could use that to sort by in a multi-column sort. Sort by the isblank column first, then column A. It should eliminate the need for the filter.