Unmerge merged cell and put value in all cells

[sa02000]

Is there any quick and easy way to unmerge merged cells and put the merged cell value in all the merged cells.

For example, if I have A6:A15 merged together and its value is "FirstMerge" then I would like to unmerge all A6:A15 and then put "FirstMerge" in all the cell A6,A7,A8 etc. etc. upt oA15.

I have lot of these merged cells in a sheet and I get this every month and makes any data processing very difficult.

A macro or VBA code or any other solution will be fine.

Thanks,
Jay