Is this a one-off, or a regular thing - if one off, copy the entire
contents of column a and paste into column B, then select column B as a
block and sort it in ascending order whcih would get rid of the blanks.
If regular, then a macro would be your best solution.