Example of Unstack Columns

An environmental scientist wants to determine whether temperature changes in the ocean near a nuclear power plant affect the growth of fish. The scientist randomly divides 25 fish into four groups and places each group into a separate, simulated ocean environment. The simulated environments are identical except for temperature. Six months later, the scientist measures the weights of the fish.

The weights of fish for all temperature levels are in the same column. The scientist unstacks the columns in order to analyze one temperature level at a time.

Open the sample data, FishWeights.MTW.
Choose Data > Unstack Columns.
In Unstack the data in, enter Weight.
In Using subscripts in, enter Temp.
From Store unstacked data, select After last column in use.
Click OK.

Results

Weight contains the original stacked weight data. Temp contains the corresponding temperature levels. Weight_38, Weight_42, Weight_46, and Weight_50 contain the unstacked weight data, with one column per temperature level.

C1	C2	C3	C4	C5	C6
Weight	Temp	Weight_38	Weight_42	Weight_46	Weight_50
22	38	22	15	14	17
18	38	18	21	28	18
22	38	22	26	21	13
24	38	24	16	19	20
16	38	16	25	24	21
18	38	18	17	23	18
19	38	19
15	42
21	42
26	42
16	42
25	42
17	42
14	46
...	...