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

@lolwat12345 One way of doing this

Duplicate_Value_19042024.yxmd