Column Actions

Linking Columns

Two columns can be linked together to display the relationship between the selected columns. For example:

• Text column + text column creates a stacked bar chart.
• Integer or decimal column + integer or decimal column creates a scatterplot.
• Country, US state, or US county + integer or decimal column creates a choropleth map.
• Latitude + Longitude entries plots coordinates on a global map.
• Time column + time column creates a timeline.

Splitting Columns

Any column can be split into two separate columns based on an entered delimiter. If a cell has multiple instances of the chosen delimiter, the cell will split on the first instance of the input you give (e.g. if you split on a comma and the cell has multiple commas, it will split the column on the first comma).

Joining Columns

Any two columns can be combined to create a new column whose data type defaults to text.

Trim

All spaces (other than single spaces between words) will be removed from text entries in a column.

Change Case

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

Merge Entries

Multiple entries can be combined and treated as a single entry.