Auto Fill a column

[bean]

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.

 

[Jacob Skaria]

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 window>Special> from options select 'Blanks'
6. This will select all blanks. Now Right click>PasteSpecial>Formulas>OK will
fill in with the data you need.
7. Once done you can select col A > Copy >Paste Special>Values to turn
formulas to actual values

If this post helps click Yes

 

[Dave Peterson]

Debra Dalgleish shares some techniques here:
http://www.contextures.com/xlDataEntry02.html
and a video here:
http://www.contextures.com/xlVideos01.html#FillBlanks

 

[YESHWANT JOSHI]

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