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 are created that 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.