List with empty spaces

[zorans]

Hi
I have list
A1=Peter
A2=0
A3=0
A4=John
A5=0
A6=0
A7=0
A8=0
A9=George

I want to B column looks like:
B1=Peter
B2=Peter
B3=Peter
B4=John
B5=John
B6=John
B7=John
B8=John
B9=George

Can anyone help?

Best regards

 

[Jon von der Heyden]

Hi,

In B1: =A1
In B2: =IF(A2=0,B1,A2) copied down to end of range.

Regards,
Jon