View Single Post
  #1 (permalink)  
Old 04-29-2008, 05:18 PM
thebigdishman thebigdishman is offline
WebProWorld Member
 

Join Date: Jun 2004
Location: U.K. - Sussex
Posts: 50
thebigdishman RepRank 0
Default Excel TRANSPOSE function

I thought I understood Excel functions, but this one has beaten me. Or maybe I am using the wrong function.

I have an Excel spreadsheet that includes various European, Russian and Greek character sets. I need to swing it round 90 degrees.

There are 28 columns and 250 rows A1 to AB250.

I need that to become 28 rows with 250 columns A1 to IP28.

Help please. I can't export and manipulate elsewhere because of the Unicode characters.

Thanks in advance.
__________________
Regards
The Big Dish Man
thebigdishman@yahoo.co.uk
Reply With Quote