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

[Luke_C · Accepted solution]

Hi @lolwat12345 

Filling values upwards is trickier than filling down. For this I usually add a record ID, sort the data to reverse the order, do the multi-row, and sort back: