Shifting rows into columns

[Guest]

I am using Excel 03, my data has 35 rows and 10 columns, but I want to shift
my current columns into my rows.

So I have 10 rows with 35 columns.

Any ideas

 

[Guest]

Select your table and click copy. Select the cell in the upper left corner
of where you want the new table to be. Click Edit and Paste special from the
Menu Bar and choose Transpose. Click OK and there you go!

 

[David Biddulph]

Copy, then Edit/ Paste Special/ Transpose.