Copy data in one cell to blank cell immediately below, repeat

J

Jeff

I have a column of data, each cell separated by a blank cell. The blank
cells need to be filled in with the data immediately above it. Fill option
to do this?
 
M

Miguel Zapico

You can use an extra column with a formula like:
=IF(ISBLANK(A2),A1,A2)
And then copy/paste values on the original column.

Hope this helps,
Miguel.
 
Top