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