The data-set that I'm working with is formatted in this way. There are also formulas in the workbook that require the cells to be merged in this way.

Is there any way around this?