Collapse values

The Collapse values operation allows you to combine all of the values in one or more fields into a single new field.

Options 

• Fields. Allows you to select the fields you want to collapse.
• Separator. Specifies how the values in the selected fields are separated.
• Collapsed field name. The name of the field containing the collapsed values.
• Skip empty cells. Determines whether empty or null values are included.
• Delete collapsed fields. Determines whether the selected fields should be deleted.