Need to fill the Blank cells from down to up

Hi,

Please help me with any formula to fill the empty cells from down to up.



Thanks,
Sriku

Select Column B and hit ctrl+G and click on 'Special'. Then select 'Blanks' and click 'OK', which will select just the blank cells in Column B. Then go click on the formula bar at the top and type =B4. IMPORTANT: after you type =B4 in the formula bar, hit ctrl+enter. Not just enter. Then you can copy the whole column and do paste special > values to remove the formulas.

Thanks a lot.