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/...tingReport.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.

--
Terry, East Grinstead, UK

Hi Terry,

Am Thu, 20 Jun 2013 17:40:12 +0100 schrieb Terry Pinnell:

https://dl.dropboxusercontent.com/u/...tingReport.jpg

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

try copy = pastespecial = transpose


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Terry Pinnell wrote:

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/...tingReport.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'...

--
Terry, East Grinstead, UK