How to copy values from cell below to cells above

Sample data attached, tried multi row formula but didn't work

Need urgent assistance with solving this problem

Workflow

Datasets

Preparation

Accepted answers

See attached solution,

I went a different route with this - i.e. not using a multi row formula - but it gets to the outcome your require.

Regards,

Ben

Here is my take on the problem using multi-row formula. I hope it helps.

I added examples of multi-row formula. If you need more assistance please let us know what is the desired output:

Thank you for quick response, the solution seems to work partially

Tried the formula, it copies the value one cell above but does not copy on the remaining cells

Here is my take on the problem using multi-row formula. I hope it helps.

Thank you, this sure does work

Appreciate your support