How to copy a column of values into another column where the cellsare merged

[biancabonilla]

Hi,

I have a sheet with a column that lists some values. I also have a
second sheet that has a column where the cells are merged every 4
rows. I need to copy the values of the first sheet into the merged
cells, but when I do, I only see every fourth value on the merged
cells. Is there a formula or any other way that I can use to be able
to copy all the values from the first sheet into the second sheet each
value on a different group of merged cells?

Thanks!

 

[Pete_UK]

Assume you have values in A1:A5 of Sheet1 that you want to copy into
Sheet2, where A1:A4, A5:A8, A9;A12 etc are merged. Put this formula in
the merged block A1:A4 of Sheet2:

=IF(INDIRECT("Sheet1!A"&INT((ROW(A1)+3)/4))="","",INDIRECT("Sheet1!
A"&INT((ROW(A1)+3)/4)))

Then copy this block into the next block A5:A8, then A9:A12, and so
on.

Hope this helps.

Pete