Issue merging cells
-
I want to merge two cells in a single column which span two other rows which are themselves comprised of merged rows; the top row has two rows merged in all columns but the last, and the second has four rows merged. The rows in final column need to remain unmerged, except for two spanning the two main rows. That is to say, I want to merge the two cells highlighted in the final column below:

However, when I do so, it just deletes the second constituent row of the merged top row:

I know it’s not due to the lack of data, as the same thing happens when all of the cells are filled, and I can’t find any settings to sort this, so I fear it may simply be impossible. Any ideas?
The topic ‘Issue merging cells’ is closed to new replies.