Copy value from previous row

[aishwarya_baburaj98]

If below is the input I have: 

Fruits	Value
Apple	12
Orange	45
Banana
Grapes	10

As you can see there is no value allocated for Banana. In this scenario, I want to copy the value above for Orange (45) to the Value column for Banana.

This way I will be having value for Banana as 45. How do I achieve this? 

[binuacs · Accepted solution]

Spoiler

[aishwarya_baburaj98]

@binuacs This is perfect. Thanks!