Excel 2007 : Blank Cells to be filled up

Attached file.

Want the cell that has a value (in Column B), that same value to be filled up in all the blank cells below that value until the next cell value comes and then the next cell value also to be filled up like this.

I have a huge sheet (thousands). Please help with the given example.