Hi there, I hope somebody here can help me. Maybe it is a very simple solution or else not possible.

Anyway I have 1 column with around 6,000 rows in use (column A)
I have another column with merged cells. (all blank) (Column B)

I would like to make each cell in the merged cells simple equal the value in the first column. This I can do easily using (=a1)

The problem is Excel doesn't seem to be finding the pattern I would like. Because I have merged cells 3 rows in size(Column B) the auto fill is going from =a1 to =a4. I would like it to simply go from =a1 to =a2 to =a3 with my fill.

Sorry if i did not explain this in a great way but I would really really appreciate anybody s help!