I have two columns of data currently in data like this (i.e., varying number of blank cells in Column B):

> 
> Column A       Column B  
> 
>  000                Alice  
> 
>  001                  
> 
>  002                  
> 
>  003                  
> 
>  004                Bob  
> 
>  005                Carlos  
> 
>  006                  
> 
>  007                Eve  
> 
> 
> 
> 

I'd like to have the value in Column B fill in the empty cells below it—even though there are different numbers of blank cells or sometimes no blank cells. So the end result would look like this:

> 
> Column A       Column B  
> 
>  000                Alice  
> 
>  001                Alice  
> 
>  002                Alice  
> 
>  003                Alice  
> 
>  004                Bob  
> 
>  005                Carlos  
> 
>  006                Carlos  
> 
>  007                Eve  
> 
> 
> 
> 

Anyone know how to automate doing this?

Cheers!