Copying issue - Function required?

[djshakes]

I have an excel spreadsheet that is about 13,500 rows. I need to copy data in a particular column. For example, in cell A13 there is a value of "2034586" cells A14 through A18 are blank. Then is cell A19 there is another value "4359874" followed by a number of blank cells. I need to populate the blank cells with with the proceeding value. Is there a function to do this?

 

[Norie]

1. Select the column with the blanks.
2. Goto Edit>Goto...Special and select blanks.
3. Goto the formula bar, enter =A13 (or whatever the first cell with data is) and then press CTRL+ENTER.
4. Select the column, copy and paste special values.

 

[iliace]

Select the entire column, then use the Go To -> Special feature, and choose "blanks". Once only the blank cells are selected, point the first one to the above. So in other words, press = then arrow up. Press Ctrl+Enter to populate all blank cells with this formula. Select the entire column once again, copy, do Paste Special -> Values.

 

[djshakes]

You guys rock. I will be using this website a lot. ****, that is awesome.