How to copy values from cell below to cells above

[MSK7244]

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

Need urgent assistance with solving this problem

[Emil_Kos]

Hi @MSK7244,

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

[MSK7244]

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

[Ben_H · Accepted solution]

Hi @MSK7244 

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

[grazitti_sapna · Accepted solution]

hi @MSK7244,

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

[MSK7244]

Thank you, this sure does work

Appreciate your support

Regards,

MSK

[MSK7244]

Thank you, this sure does work

Appreciate your support