hi bean, try this
assuming you are using column a & b and data is starting from row no. 2,
in cell c2 type the following equation :
= a2
and in cell c3
=if(a3="",b2,c3) ........... copy down the formula as per your requirement

click yes below if it helps

"bean" wrote:

I have a list in a colum, with blanks in between filled cells.

row value(current) value (desired)
1 AA AA
2 AA
3 AA
4 BB BB
5 BB
6 CC CC
7 CC
8 CC
9 CC
10 DD DD

This is a huge table. Is there any quick solution to autofill?
Thanks.