Copy non merged to merged cells

[jamalhakem]

Hi
I have 2 sheets, in sheet 1 I have
A B
1 Name Number
2 Name Number
3 Name Number
Etc….
In sheet 2 I have:
A1, A2, and A3 merged, B1, B2, and B3 merged, etc…
Any way to copy and paste the data in sheet1 to sheet2 in a way that
in merged A1, A2 and A3 in sheet2 have the same data in A1 in sheet1,
in a way to copy and paste many columns, up to 900 columns, in an easy
way, not copying and pasting every cell.
Thanks in advance
Jam

 

[Pete_UK]

Do you mean that you want A1 and B1 from Sheet1 to go into A1/A2/A3
and B1/B2,B3 of Sheet2, and then for A2 and B2 of Sheet1 to go into C1/
C2/C3 and D1/D2/D3 of Sheet2, and so on? So that you are copying
across Sheet2 for cells that go down Sheet1?

If so, then you can put this formula in A1/A2/A3 of Sheet2:

=INDEX(Sheet1!$A$1:$B$450,INT((COLUMN(A1)+1)/2),MOD(COLUMN(A1)-1,2)+1)

adjust the range to match your data in Sheet1, and then copy across
Sheet2.

Hope this helps.

Pete

 

[Pete_UK]

I see you have started a new thread, as you want to copy down rather
than across. See my response there.

Pete