Combine

Use the Combine column action to merge the data from two or more columns into a new column.

To combine columns, follow the steps below:

  1. Select the menu icon that appears on the right-hand side of the column header of any column in your worksheet.
  2. Select Combine under Column Actions.
  3. Select one or more columns to combine with your current column under Columns.
    Note

    You can delete a column by deselecting it from the list of Columns or by clicking the x that appears next to the column under Selected Columns. You can also reorder columns under Selected Columns using drag-and-drop.

  4. Check the Selected Columns section to ensure that you have the desired columns selected and make any changes if necessary.
  5. (Optional) Choose a separator value for the data using the pre-defined options or create your own.
  6. Enter a Column Name for the newly combined column.
  7. Click Apply.

    A new column appears to the right of the column you began with.