Need help with formula to fill entries until different value

[JumboCactuar]

Hi,
unsure how to do this, as theres is sometimes gaps in column A

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Helper Column[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]John[/TD]
[TD]=B2[/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD][/TD]
[TD]"this should output "John"[/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD][/TD]
[TD]"this should output "John"[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]blank[/TD]
[/TR]
[TR]
[TD]004[/TD]
[TD]Tim[/TD]
[TD]"this should output "Tim"[/TD]
[/TR]
[TR]
[TD]005[/TD]
[TD][/TD]
[TD]"this should output "Tim"[/TD]
[/TR]
[TR]
[TD]006[/TD]
[TD][/TD]
[TD]"this should output "Tim"[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]007[/TD]
[TD]John[/TD]
[TD]"this should output "John"[/TD]
[/TR]
[TR]
[TD]008[/TD]
[TD]Tim[/TD]
[TD]"this should output "Tim"[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


hope this makes sense. Appreciate any help

 

[Marcelo Branco]

Maybe...

C2 copied down
=IF(A2="","",LOOKUP(2,1/(B$2:B2<>""),B$2:B2))

M.

 

[BobUmlas]

In C2, filled down:
=IF(A2="","",IF(C1="",B2,IF(B2<>"",B2,C1)))

 

[JumboCactuar]

Both work thanks