Merged cells are evil - fact.
Not sure if this is exactly what you are after, but maybe linked Picture is the answer? I have added another sheet called View.
I then copied rows 1 to 19 from Multi Columns, clicked on view sheet, right click paste special > linked picture and then copied rows 19 to 40 from Min Columns clicked on view sheet, right click paste special > linked picture.
The view page then gives you the print view in 1 sheet and as they are linked Pictures then will update, so it might be possible to set this up to be a standard template
|