# Restructuring Data in SPSS – Overview

SPSS offers several simple ways for restructuring data. VARSTOCASES -short for “variables to cases”- stacks variables on top of each other.

Its reverse is **CASESTOVARS** -short for “cases to variables”. It basically stacks groups of cases behind each other in new variables.

AGGREGATE adds summary statistics such as frequencies, sums and means to your data, optionally collapsing cases in the process.

Finally, **FLIP** basically transposes data by rotating the entire dataset by 90 degrees.

# SPSS VARSTOCASES Tutorials

## SPSS VARSTOCASES – What and Why?

SPSS VARSTOCASES is short for “variables to cases”. It restructures data by stacking variables on top of each other. This tutorial also shows a major pitfall in SPSS VARSTOCASES. Read More

## SPSS VARSTOCASES With Labels Tool

Simple, menu based tool for running SPSS VARSTOCASES while retaining variable labels of input variables. Comes in very handy for creating nice charts and tables. Read More

# SPSS AGGREGATE Tutorials

## SPSS AGGREGATE Command

Aggregate is an SPSS command for creating variables holding statistics over cases. This tutorials briefly demonstrates the most common scenarios and points out some best practices. Read More

## Disaggregate Data

Sometimes, one may start a project with aggregated data, weighted by a frequency variable. In some cases, though, disaggregating such data (creating *n* rows for a row with frequency *n*) may be desired. Read More