a1,"text" b1,"text"
a2, empty" b2 "text"
a3 "text" b3 "text"
a4 "empty" b4 "text"
So, I need a macro that will look for empty/blank cells a1:a4, and merge the text in the cell to the
right of the empty/blank cell into the text above it.
Then somehow get rid of the empty rows without deleting them as i have other text in a5 that needs to stay in a5.