How to invert Cols/Rows?


Ad

Advertisements

Ad

Advertisements

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.


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

Top