How to Copy the value from the row above into blank cells

[sgtnobleusa]

:?:I would like to copy the value in column 1 down until it reaches a new value and then copy that etc until it reaches the end of column.
Example:

Column1*********Colmun 2
BBKHSP305*******data here


BBKHIN310******* data here


Result should look like this
Column1**********Colmun 2
BBKHSP305********data here
BBKHSP305********data here
BBKHSP305********data here
BBKHIN310********data here
BBKHIN310********data here

Thank you

[Bob Hansen]

This works in single step replacement mode:

Find: ^(.+)\n\n
Replace with: \1\n\1\n

Use the following settings:
-----------------------------------------
[X] Regular expression
Find Next
Replace
-----------------------------------------
Configure | Preferences | Editor
[X] Use POSIX regular expression syntax
-----------------------------------------