Copy data from unmerged to merged cells

[ashani]

Hi
I wonder if someone could guide me pls : I have a series of database and I want to copy into different worksheet but in the new sheet there are 7 rows merged, please can you give me any formula to copy those database from unmerged standard database to merged rows. The row from A to C

Many thanks

 

[6StringJazzer]

We would need a lot more detail. "7 rows merged" is not specific enough. Specifically what cells are merged? Specifically what unmerged cells do they map to? Why is this even a problem? If you have cells A1:F1 in worksheet Sheet1 merged, then you can use =Sheet1!A1 to get the value.

Also, don't merge cells. It's generally a terrible design, and this question illustrates one of the many reasons why.