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
Excel 2003 - How to print a large worksheet that is actually readable 2
Transpose not working rows to columns 3
Getting "Per Item" Pivot Chart Results when data rows are identica 4
200 COL Excel file with 700 rows -how to switch COLS & ROWS in ACC 2
how can i lock columns but allow for new rows to be added? 3
How to reverse order of rows and columns 3
how to define how may rows or columns are present in excel 03 1

Top