Unstack Columns

Data > Variable > More > Unstack

 

Use Unstack Columns to split the contents of a stacked column into two or more shorter columns within your current datasheet or copy the split columns to a new datasheet. For instance, you might unstack a data set so that the Value data for each Group is stored in a separate column.

In the following illustration, the Value column contains the stacked values figures from groups A, B, C, D and E. Unstack Columns splits this column into five separate columns based on the label in the Group column. The data in the Value column are unstacked (split) into the Value_A, Value_B, Value_C, Value_D, Value_E columns.

 

Variety of Pea

Value

Group

26.2

A

24.3

A

21.8

A

28.1

A

29.2

B

28.1

B

27.3

B

31.2

B

29.1

C

30.8

C

33.9

C

32.8

C

21.3

D

22.4

D

24.3

D

21.8

D

20.1

E

19.3

E

19.9

E

22.1

E

                                    arrow_down

Variety of Pea

Value_A

Value_B

Value_C

Value_D

Value_E

26.2

29.2

29.1

21.3

20.1

24.3

28.1

30.8

22.4

19.3

21.8

27.3

33.9

24.3

19.9

28.1

31.2

32.8

21.8

22.1

Some statistical software require a grouping variable, where all data are expected to be in a single column. VisualStat does not require this because data in separate columns can help in understanding the analysis. If you need to share data between VisualStat and statistical software that require grouping variable, then use this function to prepare data prior to import/export.

 

Dialog box items

Variables to Unstack:
Select the columns you want to unstack.
To select nonconsecutive columns, press and hold down CTRL, and then click each item.
You can select many columns. Use the Ctrl key to select (or unselect) distant columns.

Group Variable:
Select the column containing the labels. The values in this column determine how the source column will be unstacked.
Note that VisualStat considers missing data as a value of label.

Sheet Name:
Specify a name for the datasheet. This may be a new datasheet or the name of an existing datasheet. Leave blank to store data in a new datasheet.

 

 

Data

Data can be numeric, text, or any type of data.

Columns are not required to be the same length.

 

 

Example

The data represents cell phone towers' signal strength in various directions by more than one carrier. This data is hypothetical and is simply an example of how the Polar chart is used. The first column represents a cellular service provider company name, followed by angular orientation and signal strength.

The data is being grouped by the chart when plotted. AT&T entries are grouped together as are the Verizon entries.

1.Open the DataBook summary.vstz

2.Select the sheet CellPhone

3.Choose the tab Data, the group Variable and the command Unstack

4.In Variables to Unstack, select Strength.

5.In Group Variable, select Company.

6.Click OK

 

 

DataSheet window output

 

Strength_AT&T

Strength_Verizon

20

90

60

40

29

19

45

105

25

60

55

30

10