If you copy your range you can then select Edit|Paste Special|Transpose,
which will tranpose your columns to rows and rows to columns. Make sure you
take a copy before you start!
Note that you cannot paste to any range that overlaps the original in any
way. Paste to another range and then move or copy the data to where it
needs to go.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
