If it isn't essential to keep the same order, then just sort the column - that will put the blanks to the bottom.