Hello, I recently stumbled across this board and believe it might be able to make my life easier, as I am just beginning to learn the wonders of Excel. This might be a rather novice question with a very simple answer, but I have yet to find one through my searches.
Since I am bad with words, I figure that a before and after shot of what I would like to accomplish would explain much better.
I have a rather larger sheet with information ordered like so.
Now while this works, I would like it much better if I could merge each item with the blank cells below them. Like so:
However, this is a rather large document and I simply cannot do them all manually. I have tried selecting each column, Go To Special > Blanks and merging, but of course that only merged the blanks together, and not with the information above them. I am using Excel 2013. All help is very much appreciated, thank you.
Since I am bad with words, I figure that a before and after shot of what I would like to accomplish would explain much better.
I have a rather larger sheet with information ordered like so.

Now while this works, I would like it much better if I could merge each item with the blank cells below them. Like so:

However, this is a rather large document and I simply cannot do them all manually. I have tried selecting each column, Go To Special > Blanks and merging, but of course that only merged the blanks together, and not with the information above them. I am using Excel 2013. All help is very much appreciated, thank you.