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


Using JMP > Enter and Edit Your Data > Restructure Data > Split a Data Table Column into Multiple Columns
Publication date: 06/21/2023

Split a Data Table Column into Multiple Columns

Use the Text to Columns option to make a character column with delimited fields into multiple columns. Highlight a column from a data table and select Cols > Utilities > Text to Columns. The maximum number of delimited fields across all rows determines the number of new columns created.

Note: Text to Columns is case-sensitive.

The Text to Columns window has the following options:

Delimiter

Specify text, such as a comma, to indicate how the data in the source column is organized into new columns. For example, if the original cell reads “NY, NJ, PA,” and the delimiter is a comma, three new columns contain “NY”, “NJ”, and “PA”.

TAB

Specifies tabs as delimiters.

NEWLINE

Specifies newline characters (\r, \n, and \r\n) as delimiters.

Make Indicator Columns

Makes new columns that are named after the distinct fields in the source column with cell values of either 0 or 1.

Include Missing

Allows any empty rows to be counted as a category. An additional column named Missing is added to the data table. A value of 1 indicates an empty row.

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