Deleting blank cells

I'm no professional Excel user, so this is either something that can't be done, or something really simple that I'm just not seeing.

I took a picture of the setup, rather than explaining it in words: http://img9.imagepile.net/img9/61555picture4.png

I want to get rid of all the blank cells so it looks like this: http://img9.imagepile.net/img9/4726picture5.png

I'd like to be able to do this without going through the process of individually selecting each blank cell. Is this possible?

Cononach,

Please read forum rules below and then amend your title

VBA Noob

Without code

Select Col A then

goto Data > filter > Autofilter then select the dropdown and choose blanks.

The blank lines will appear blue. highlight these lines and delete. Turn off autofilter and job done

HTH

VBA Noob