View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default 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?