Multi-row formula - Duplicate a value in the middle

[lolwat12345]

Hello, I have a dataset like this

Multiplier
0
0
0
0.75
0
0
0.5
0

I need to convert it to this:

Multiplier
0.75
0.75
0.75
0.75
0.5
0.5
0.5
0

Could anyone help suggest a formula please, tks

[binu_acs · Accepted solution]

@lolwat12345 One way of doing this