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

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?

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.

"Jeff" wrote:

> 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?