Detabulate

 

Menu location: Data_Grouping_Detabulate.

 

This a function to expand a two way table of counts into a column indicator variable and a row indicator variable, i.e. to deconstruct a table back into individual level data. This is the opposite of crosstabs or the tabulate function.

 

Example

Given the following table:

 

	reaction:0	reaction:1	reaction:2
sex:0	2	2	1
sex:1	1	1	3

 

You can use the Data_Grouping_Detabulate menu item on the two by three table of counts to get back to individual level data with each row representing the classification of a subject as follows:

 

Row Classifier	Column Classifier
0	0
1	1
1	2
0	2
1	2
0	1
0	0
0	1
1	2
1	0