Split

Use the Split column action to separate the data from one column into a multiple columns.

To split columns, follow the steps below:

  1. Select the menu icon that appears on the right-hand side of the column header of a column you wish to split in your worksheet.
  2. Select Split under Column Actions.
  3. Choose a value to indicate where column splits should happen.
    For example, if you have a column that has First Name/Middle Name/Last Name, you may split on the value / so that three columns are generated with the first name, middle nam, and last name.
  4. Press Enter on your keyboard.

    The data that will go in each new column will appear highlighted in a different color to show where the splits will occur.

  5. (Optional) By default the Detect Number of Columns option is on. This option will automatically show the number of columns that the application detects based on the given separator value. If you wish to define the number of columns manually, turn this option off.
  6. Enter a Column Name for each of the new columns.
  7. (Optional) By default, all the new columns are Required, so the application will look for values in every column. You can change the priority of each of the new columns by selecting the checkmark that appears next to the column name. Columns can be set to Required, Optional, or Ignore.
    Note

    • The newly split columns are filled from left to right. For example, if there are two Optionalcolumns but only one value, the value is assigned to the first Optional column

    • Required columns take precedence over Optional and Ignored columns.

    • An Ignored column is treated as an Optional column that will not appear in the output.

    For example, if some of your data has first, middle, and last names of customers and some customers do not have middle names, you may set the middle name column priority to Optional so that when the split occurs, the application will leave the middle name column empty for those who do not have a middle name.

    If you wanted to eliminate the middle name altogether, you may set the middle name column priority to Ignore.

  8. Click Apply.

    The newly split columns appear to the right of the column you began with.