Hi

I have Text(Peoples Names) in Column A of a worksheet with blank spaces in
between. I need to copy the Text(Peoples Names) to the next cell in the
column. My reference would always have to be the Cell above. If the next
Cell contains Text(Peoples Names) then this will be the next reference until
the first entire blank row is detected or Blanks are detected in Column B.

A1 = Julian
A2 = Blank
A3 = Jack
A4 = Blank
A5 = Blank

Result A2 to be Julian and A4 and A5 to be Jack

I would appreciate any help.

Thanks
Julian