Merge cells - empty cells with a cell with value

Hi All,

I want to merge cells with a value with empty cells. I have attached the excel file for easy understanding.

Further, it is much appreciated if the range can be changed according to the lenght of the table.

Thanks in advance.

Thanks,
Suravi