How to invert Cols/Rows?

  • Thread starter Thread starter Terry Pinnell
  • Start date Start date
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'...
 
Back
Top