Menu location: **Data**

- GENERATING
- CLEANING AND ENCODING
- TRANSFORMING AND DERIVING
- ORGANIZING
- Sort data range within worksheet
- Create sorted variables
- Rotate blocks of data
Combine variables into a data variable plus an identifier variable

- Split a data variable by an identifier variable
- Create a set of binary dummy variables to represent a variable with more than two categories
- Extract a subset of data
- Tabulate count variables into tables
- Detabulate tables into count variables
- Expand a set of unique observations and counts
- Contract a set of observations into unique values and counts

See also: Crosstabs and Frequencies in the Analysis menu.

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