How to invert Cols/Rows?

T

Terry Pinnell

Terry Pinnell said:
Long time since I last did this and I've forgotten how!

I want to 'invert' this report so that rows and columns are reversed:

https://dl.dropboxusercontent.com/u/4019461/Excel-InvertingReport.jpg

That will allow me to use a portrait instead of landscape format.

The only hits I had in Help for 'invert' appear to be about 'Pivot
Reports', which looks far too complex for this simple job.
Click to expand...


Got it! Seconds after posting I remembered the term was 'Transpose'...
 

Ask a Question

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.

Ask a Question

Similar Threads

Cannot remove empty rows 8
Remove date format? 3
How to export html text as word document with specific size and orientation 0
Displaying time gaps 6
Excel 2003 - How to print a large worksheet that is actually readable 2
Getting Two Rows in A Pivot with Identical Data 0
Suppressing Blank Rows 0
How to alternately variegate rows 2

Top