Help Centre

Combine Columns

About Combine Columns

The Combine Columns operation creates a new column which combines (concatenates) the content of multiple other columns. Optionally, a separator character can be included between each column’s content.

Unlike the Concatenate function in Calculate, if named columns are not present, the operation will continue to function, ignoring any missing columns.

Example

Combine the columns ‘Street’, ‘City’, ‘State’ and ‘Zip’ with comma and space separator.


Street
City
State
ZIP
Combined address
1063 Perry Ct
Anchorage
AK
99517
1063 Perry Ct, Anchorage, AK, 99517
PO Box 379
Trapper Creek
AK
99683
Po Box 379, Trapper Creek, AK, 99683
84 Redwood Ave
Kaktovik
AK
99747
84 Redwood Ave, Kaktovik, AK, 99747