I posted this in the formulas forum, but I'm unsure as to the protocol on this forum. Below is my question:
Currently I have a blank space between descriptions on my spreadsheet and I want to get rid of those blank spaces.
I cannot delete the middle space so I am trying to skip it.
Example:
A1 = text description
A2 = Blank
A3 = text description
A4 = Blank
So on and so forth until cell A1600
I'd like to have an output that looks like this:
B1 = text description
B2 = text description
With the text descriptions coming from A1 and A3.
Hope that's clear :-) help is much appreciated.
-Ryan
Bookmarks