Manipulating Data

Last modified: June 11, 2025

The column actions dropdown contains operations you can take to create new columns based on the current column, or just alter the current column.

Splitting columns

Any column can be split into two new columns, based on an provided delimiter. If a cell contains multiple instances of the given delimiter, you can choose to split the cell on either the first or last instance of the delimiter.

The data types of the resulting columns will be text.

Joining columns

Any two columns can be concatenated into a new column, using a provided separator.

The data type of the resulting column will be text.

Trim

All leading and trailing spaces will be removed from text entries in a column.

Single spaces between words will not be affected.

Change case

All text entries in a column can be changed to uppercase or lowercase.

Merge entries

Multiple text entries can be combined and treated as a single entry. The resulting combined entry will be labeled by the most frequent .

For example, if a column contains the entries "new york", "new york city", or "nyc", you could merge the three, resulting in any occurrence of those terms being renamed to "new york".

Revert column changes

Any "trim", "change case", or "merge entries" operations will be reverted, returning the data in the column to the original state.