Formula to populate following cells based on previous cells

[randrze2]

Hello, I am trying to figure out a formula that will help me populate cells based on the sample instance below. I've tried different IF statements but can't seems to get it to work right. Any help is greatly appreciated. Thanks!

Name (current)	Name Populated All the Way down (formula)
Rob	Rob
	Rob
	Rob
Jeff	Jeff
	Jeff
Steve	Steve
	Steve

<tbody>
</tbody>

 

[oldbrewer]

in B1 =A1

in B2 =if(a2="",B1,a2)

drag down

 

[Special-K99]

Use 2 columns A and B
With names and blanks in column B do the following

in B1
=A1
in B2
=IF(A2="",B1,A2)
and copy down column B

 

[gaz_chops]

Try
In cell B1
Enter =A1
In cell B2
Enter =if(A2="",B1,A2)

 

[oldbrewer]

threes a crowd...........