Hello,

This is my first post here, I decided to sign up as I have a problem and the answers on here are usually good!

Is it possible to use an Excel function to copy text spanning a random number of blank rows, as shown below? (* used for spacing and to indicate blank rows)

Col A*****Desired Column B
Apple*****Apple
*********Apple
*********Apple
Banana***Banana
*********Banana
Carrot****Carrot
Damson***Damson
*********Damson
*********Damson
*********Damson
*********Damson
More text*More text
*********More text

etc