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?
Solved! Go to Solution.
@binuacs This is perfect. Thanks!