When I split a cell that is merged across two rows, it works great; however, when I split a cell that is merged across three or more rows, it shifts all but the first two rows to the left one cell:
Original (dots are merged with columns a, b, and c respectively:
a b c 1 2 3
. . . 4 5 6
. . . 7 8 9
New format after splitting column c (underscore represents an empty cell):
When I split a cell that is merged across two rows, it works great; however, when I split a cell that is merged across three or more rows, it shifts all but the first two rows to the left one cell:
Original (dots are merged with columns a, b, and c respectively:
New format after splitting column c (underscore represents an empty cell):
This is what it should look like instead: