For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Enter and Edit Your Data > Restructure Data > Combine Columns in Data Tables
Publication date: 06/21/2023

Combine Columns in Data Tables

The Combine Columns option is the opposite of Text to Columns. Instead of making multiple columns, you can combine a set of columns into one character column with delimited fields.

To combine indicator columns, follow these steps:

1. Select Help > Sample Data Folder and open Consumer Preferences.jmp.

2. Select the columns, Floss After Waking Up, Floss After Meal, and Floss Before Sleep.

3. Select Cols > Utilities > Combine Columns.

4. Type “Combined Floss” for the column name, and keep the default delimiter as a comma.

5. Select Selected Columns are Indicator Columns and click OK.

Figure 4.36 Combined Floss Column 

Combined Floss Column

The selected columns are represented in the Combined Floss column with each field separated by a comma. Only the columns that have a value of 1 are represented in the combined column for each given row.

Note: Value labels show a label in the data table instead of a value. A label appears for each instance of the value in the combined column. You can show the original values by double-clicking a label within a cell. To avoid using value labels, select No Value Labels when you combine the columns.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).