Hi All! Great forum you have here and the resources available here via search are great. I haven't found what I'm looking for - so I'm hoping you all can assist with something I think is quite simple .. but I keep hitting a wall.

I have a situation in Excel that currently looks like this:

Column A
a
<blank>
<blank>
b
<blank>
<blank>
<blank>
<blank>
c
<blank>
<blank>
<blank>
<blank>
<blank>
<blank>
d
(^^ each line represents a row ^^)

This goes on for several thousand lines - sometimes there are no blanks, sometimes 1 and sometimes 30 or more.

What I'd like to do is find a formula I can use on the column to the left (or right) of the data above to create a consistent list without blanks as seen here:

Column A
a
a
a
b
b
b
b
b
c
c
c
c
c
c
c
d
(^^ each line represents a row ^^)

Essentially, I want to fill in the blanks after each value with the value from above - when I reach a new value I want to fill in the blanks after the new value with the data from the new value.

I hope I've explained this well enough. Thank you in advance for your help!

-E