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.