Joining Columns
Michael,
Put this formula in A1 on the new sheet,
then drag fill down and fill right to C2500.
=OFFSET(Sheet1!$A$1,(ROW()-1)/50,COLUMN()-1)
Put this formula in D1 on the new sheet,
then drag fill down and fill right to F2500.
=OFFSET(Sheet1!$E$1,MOD((ROW()-1),50),COLUMN(A1)-1)
--
Regards,
Soo Cheon Jheong
Seoul, Korea
|