How to copy into multiple rows from merged cell (or from 1 row)

Hello,

I have merged cells which are associated with several rows in lots of columns. I would like to copy the values in merged cells into multiple rows which are associated with the merged cells.

With the attached picture, I can explain better: Basically, I want to copy the 'Iso Date' field into the associated 'Date' fields. So The cells B2 - B18 will have 2010-07-17 in them and B19 - B34 will have 2010-07-18 in them, and so on.. The sizes of merged cells vary.

I appreciate if anyone can explain me in detail how to do this. Macro's are also welcome.

Thanks a lot..