Switching rows and columns in Excel

  Housten 11:35 01 Oct 2009

I don't know if this is even possible, but if it is, is there anyone who can tell me how to accomplish this?
What I get is a spreadsheet with about 65 rows and 6 columns wide, and I would like to change this to 6 rows and 65 columns wide. I know I can do it manually, but it would be so much more simple if it was possible to be done by a formula.
Any other ideas would also be gratefully received.

  VoG II 11:37 01 Oct 2009

Copy the data.

Select a cell where you want the switched data placed then Edit > Paste Special, tick Transpose and click OK.

  Housten 12:09 01 Oct 2009

Many thanks!!Isn't always the same?? The nswer is right under your nose??? I have used spreadsheets for years and 'copy and paste' times without number and yet I never knew about this capability!! My life will be much simpler now! Thank you once again!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone