I have a large table of data (about 30,000 rows) from which I want to
create a pivot table. Before I can do that though I have several
blanks cells which I need to fill in.

E.g. I have a value in cell A1 which should apply to cells A1 down to
A10 (but A2-A10 are currently blank). Then another vaue sits in A11
and needs to be applied vetically down for several rows.

I can fill in the blanks by selecting A1 and double clicking on the
cross hair in the bottom right corner of excel, this fills the value
down to A10.

But how can I do this for the whole 30,000 rows of data without having
to double click on every cell where there is a value in order to fill
down the column - this would take hours!

Thanks!


--
morchard
------------------------------------------------------------------------
morchard's Profile: http://www.excelforum.com/member.php...o&userid=24761
View this thread: http://www.excelforum.com/showthread...hreadid=383305