Auto fill a column

D

Dave R

How do I auto-fill a column with data from above, filling all the empty
spaces below?

Example:

Product number Date
123 12/10/09
12/11/09
12/12/09
XYZ 12/10/09

I want to fill the cells between product number 123 and XYZ with 123.

I hope this makes sense.
 
Top