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.
![NG5wsOo.jpg](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FNG5wsOo.jpg&hash=fe5d2af58ae48b3c27f4a297a717f8c2)
Now while this works, I would like it much better if I could merge each item with the blank cells below them. Like so:
![K7UK5Pl.jpg](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FK7UK5Pl.jpg&hash=24dca3dc73d269357a37e1182ca2bd8c)
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.