Tools and tricks for manipulating data files

PivotTables in Excel

If you want to produce cross-tabulated summaries of your data in an Excel spreadsheet, then it is worth exploring the use of Excel's PivotTable Reports.

or the keystroke sequence

There is a special toolbar for pivot tables. It can be switched on via the Menu sequence

Data Restructure (SPSS 11)

This seems to be the perfect tool for all those occasion when you want ...

  1. To combine data from two or more rows (cases) of a data matrix in a single row (case). The Restructure Wizard calls this Restructure selected cases into variables');

  2. To split a single row (case) into two or more rows (cases). The Restructure Wizard calls this Restructure selected variables into cases');

  3. To swap rows and columns (i.e. simply tanspose the data matrix).


Return to Statistics main page

Return to CBU main page

These pages are maintained by Ian Nimmo-Smith and Peter Watson

Last updated on 2 July 2006