An example would be:
Cell A1 = Text 1
Cell A3 = Text 2
Cell A5 = Text 3
Cell A7 = Text 4
I would like to insert a formula in cell B1 and down that would result in:
Cell B1 = Text 1
Cell B2 = Text 2
Cell B3 = Text 3
Cell B4 = Text 4
Basically it removes any blank cells in column A
Thanks