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?