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.
|