Copying between Sheets

Posted by KK on January 04, 2002 2:35 PM

I am trying to copy data from Sheet1, so data in fields H2, I2, J2, K2, L2,...IV2 are transferred to Sheet2 as H2, H3, H42, H5, H6,...H65536
What would be please the formula to use?

Thank you very much in advance.

Posted by Scott on January 04, 2002 2:41 PM

You can copy row 2 and then go to sheet 2 and select H2, and paste-special and then check the "transpose" box.

Posted by Ken on January 04, 2002 2:43 PM

Use Paste Special, Transpose

I would copy the Sheet1 range, select Sheet2 right click select Paste|Special|check transpose.