i have some data in Sheet 1different rows like eg (A1,A2,A3...), ( B1,B2,B3) , (C1, C2,C3) etc

i have to copy all the data into another sheet (sheet 2) and this sheet has merged cells like eg (A123456789), (B123456789), (C123456789) merge Rows

copy from sheet 1 (A1,A2,A3) into sheet 2 merge cell (A123456789)....

Help needed urgently

thnx in adv