Follow the below steps..It is too easy; but there are 7 steps since I have
elaborated.

1. Select an unused cell out of the data range (say E2)
2. Enter the formula in cell E2 which references the top cell (=E1)
3. Copy the cell (not the formula)
4. Keeping the copy; select the data range in ColA (say A1:A100).
5. Press F5. From Goto windowSpecial from options select 'Blanks'
6. This will select all blanks. Now Right clickPasteSpecialFormulasOK will
fill in with the data you need.
7. Once done you can select col A Copy Paste SpecialValues to turn
formulas to actual values

If this post helps click Yes
---------------
Jacob Skaria


"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.