Writing a function

Ok. Need some help here.

I need to write a function that returns the value of a merged cell that I can plug in to a spreadsheet to get the value of the merged cell to the right.

Here is what I am trying to do.

So I have a colum of data 1000 lines. Some of the cells are merged together in the collum some are not. I need a formula to return the value of the cell to the left in the cell to the right. If the cell to the left is merged. I need the merged value in all the cells to the right of the merged cells. Some of the merged cells are three cells, others are up to 10 merged cells in a collum. There are also merged cells with blanks I need to return a blank cell to the right. Also Merged cells with a blank below a merged cell with a value. Like the photo listed.


See example.