Skip to main content
Merge Columns lets you combine multiple columns into a single output column using priority-based fallback logic. Databar picks the first non-empty value from your ordered list of source columns, giving you a clean, consolidated result.
Merge Columns is a transformation. It does not consume any credits.

​
When to use

When the same data point exists across multiple columns (often because you enriched from different providers), you end up with fragmented values. For example, you might have a company name from Apollo, another from Clearbit, and a third from your CRM import. Merge Columns resolves this into one authoritative column.

​
How to use

1

Add a Merge Columns transformation

Open your table, add a new transformation column, and select Merge Columns.
2

Select columns in priority order

Choose the columns you want to merge. The order matters. Databar will use the first non-empty value it finds, working from top to bottom.
3

View the result

A new column appears with the best available value for each row.

​
Example

Suppose you have three columns for company website: With Merge Columns set to priority order Apollo → Clearbit → Import, the result column would contain: The first non-empty value wins.

Tables overview

Learn how tables work in Databar.

Excel formulas

Use formulas for more complex merging logic.