I need to search a column that has 7000 rows. see below...

Column C
-----------
B010
need this filled down with B010


B767
need this filled down with B767

C756


need the rest filled down with C756


So if it is a blank cell. I want it to take the previous cell that has data to fill..

Hope this makes sense, any help is appreciated. Thanks in advance.