Combine Columns Online

Merge two or more columns into one, joined by any separator you choose.

100% private. Everything runs in your browser. Your data never leaves your device.

Combine Columns

What does this tool do?

This tool merges two or more columns of data into a single column, joined by a separator you choose (space, comma, dash, or custom). Paste your columns and it stitches each row together. Runs entirely in your browser.

How to use Combine Columns - Free Online Tool

  1. Paste each column into its own box (or click "Try with sample data").
  2. Choose the separator to place between values.
  3. Click Combine.
  4. Copy the merged column or download it.

Example

Combining first and last name with a space:

Before

First Last
John Smith
Mary Jones

After

Combined
John Smith
Mary Jones

Each row is joined into one value using your separator.

Excel formula alternative

Prefer a formula? You can achieve a similar result with TEXTJOIN:

=TEXTJOIN(" ", TRUE, A2, B2)

Excel's TEXTJOIN or & operator joins cells. This tool joins whole columns at once with any separator.

When should I use this tool?

Joining first and last names
Building full addresses from parts
Creating unique keys from multiple fields
Combining codes with descriptions
Merging city and country columns
Assembling labels for reports

Frequently Asked Questions

No. Combining happens in your browser and your data never leaves your device.

Space, comma, dash, or any custom character or string you type.

You can combine two or more columns; add as many as you need.

Rows are joined by position; missing values are simply skipped in that row.

Related tools

Split Text (Text to Columns)
Split Full Names
Add Prefix / Suffix
Change Text Case
Excel Formula Generator

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator