<< Click to Display Table of Contents >>
## Pivot |

Creates a pivot table to summarise values for one or two columns.

One.

•Use Pivot column to select the column values you want to use as columns in your pivot table.

•Use Pivot row to select the column values you want to use as rows in your pivot table.

•Use Pivot sum to select which column you wish to sum.

•Pivot tables are very useful for analysing data.

•Any non-numerical values in the Pivot sum column are ignored.