This article describes how to split grid questions (Pick Any - Grid and Number - Grid into new questions which correspond to either the rows or columns of the grid. This is useful when the software has combined a grid automatically when the user has imported their data set, and they either don’t want to analyse it as a grid or they also want to analyse row or column categories separately in addition to analyzing the grid as a whole.
For example, let's say I have this Pick Any - Grid variable and want to split the row variables (Coke, Diet Coke, ... None of these) off into new questions, or I want to split the column variables (Feminine, Health-conscious, ... Weight conscious) off into new questions.
A variable with one of the following structures:
- Pick Any - Grid
- Number - Grid
- Create the table you want to split
- Select Automate > Browse Online Library > Create New Variables > Split Grid by Columns (Split Grid by Rows)
- Select Automate > Browse Online Library > Create New Variables > Split Grid by Rows