Stack Columns

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Reshape Data • Stack Columns

•

You can rearrange your data table by stacking two or more columns into a single new column, preserving the values from the other columns. Or, you can stack a set of columns into multiple groups. The various ways that you can stack columns are explained in Stack Options.

To stack columns, follow these steps:

1.

Select Tables > Stack.

Figure 5.8 Stack Window

2.

Highlight the names of the columns that you want to stack and click Stack Columns.

3.

Customize your stacking further using the additional options.

4.

Select Columns Filter Menu

Contains options to search and filter through columns. See Column Filter Menu in Get Started.

Multiple series stack

Stacks selected columns into two or more columns. Specify the number of columns into which you want the selected columns to be stacked by entering the number into the Number of Series box. This box appears when you check the box beside Multiple series stack.

Select the Contiguous option if the series consists of adjacent columns.

See Example of Stacking into More Than One Column.

Note: The order in which you add columns to the box on the right determines the group to which they belong.

Stacks columns by rows. Deselect the option to stack one column underneath another. Selected by default.

Eliminate missing rows

Eliminates missing data from the new table. If Stack by Rows is checked also, only rows with all data missing are eliminated.

Non-stacked columns

Includes or drops non-stacked columns from the new data table. Select one of these options:

Includes all of the non-stacked columns from the original table in the new table. Selected by default.

Omits the non-stacked columns from the new table.

Select the non-stacked columns that you want to include or drop in the new table.

Keep dialog open

Keeps the Stack window open after you click OK.

Adds the columns that you want to stack.

Removes any highlighted columns.

Output table name

(Optional) Specifies the name of the new table.

Stacked Data Column

Assigns a name to the column that will contain the data for the stacked columns. The default name is Data. Leave the box empty if you do not want this column to appear in the new table.

Source Label Column

Assigns a name to the column that will contain the original table’s column names. The default name is Label. Leave the box empty if you do not want this column to appear in the new table.

Includes formulas from the original table in the output columns. Selected by default.

Suppress formula evaluation

Prevents JMP from evaluating columns’ formulas when the new table is created. Selected by default.

•

Help created on 10/11/2018