Copy data in one cell to blank cell immediately below, repeat
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?
|