Rotate Data Block

 

Menu location: Data_Organizing_Rotate.

 

This function rotates a selected block of data from a StatsDirect workbook in the following way:

 

Example

  1.. 2.. 3..
1: 1.1 0.7 1
2: 1.5 0.6 2
3: 1.6 0.6 3
4: 1.8 0.5 4

 

...this would become:

 

  1.. 2.. 3.. 4..
1: 1.1 1.5 1.6 1.8
2: 0.7 0.6 0.6 0.5
3: 1 2 3 4

 

... in other words rows become columns and columns become rows.

 

The resulting rotation is best saved to a new workbook.

 

You are given the option to keep existing formulae or to translate them into results before rotation. Please note that if you keep formulae and save your rotated data to another worksheet, the references in the formulae are likely to be incorrect.

 

 

Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.