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

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!

"biggg_fish" wrote:

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

Copy, then Edit/ Paste Special/ Transpose.
--
David Biddulph

"biggg_fish" wrote in message
...
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