Multi-row Formula

[AmitBelagali]

Hi,

I have a scenario wherein, I need to populate the current cell with based on row+1. (The reverse of row-1).

Could you please help me on how to achieve it?

I have attached a sample attachment as well. 

Thanks,

Amit Belagali

[Kenda · Accepted solution]

@AmitBelagali Try sorting your data in the opposite way first using the Sort tool. Then fill down and then re-sort your data back to the original format.