First of all, Merged Cells are there only to improve the look of your sheets.
So it is literally the last thing that you should do, once your sheet and workbook are totally functional!
Where is the data in a Merged Range?
When you merge a Range, you'll only display one block.
The data will be ...
