Excel: removing blank cells and shifting the rest up
I've got a column of about 2000 names with random empty cells between them. Deleting them one by one takes forever. Is there a quick way to remove all the blanks so everything moves up?