Merge Columns
Merge Columns combines two or more columns into a single value, joined by a separator you pick.
What it does
- Takes any number of source columns and concatenates their values into one output
- Lets you set the separator — space, comma, hyphen, or custom text
- Skips empty source values instead of leaving stray separators behind
Common use: build a Full Name column from First Name + Last Name, or a combined address from street, city, and state.
How to use it
- Click Add Action and search “Merge Columns”
- Select the columns to combine, in order
- Set the separator
- Run the row, then the column
Common use cases
- Build a Full Name column from First Name + Last Name for a CRM that wants one field
- Combine street, city, and state into a single address line
- Join a signal to a company name to make one personalization string
- Build a composite key — company + country — to dedupe a messy list on
Best practices
- Pick the column order deliberately; it is the order they will read in
- Set the separator explicitly — a space for names,
,for addresses, nothing for keys - Test a row where one of the source columns is empty and check the output still reads correctly
- Clean and normalize the sources first, then merge — merging messy values just hides the mess
- Keep the source columns; the merged column is a convenience, not a replacement
Where to next
- Separate Name — the reverse: split one name column into first and last
- Actions — dynamic variables and how columns chain together