Thread: Joining Columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Soo Cheon Jheong Soo Cheon Jheong is offline
external usenet poster
 
Posts: 14
Default 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