How to Combine Two Columns in Google Sheets

Combining columns in Google Sheets is a useful skill when you're organizing names, addresses, or other related data. Instead of manually copying and pasting, Google Sheets offers easy formulas to merge the contents of two columns into one.

Whether you're combining first and last names, product codes and descriptions, or any other paired data, this tutorial will guide you through simple, efficient methods.

In this step-by-step guide, you’ll learn how to combine columns using formulas like CONCATENATE, the & symbol, and TEXTJOIN for more advanced merging.

Step-by-Step: How to Combine Two Columns in Google Sheets

Method 1: Using the `&` Symbol

Open your spreadsheet with the two columns you want to combine.

Select an empty column to place the combined result.

In the first cell of the new column, type the formula:

This combines the values in cells A2 and B2 with a space in between.

Press Enter, and then drag the fill handle down to apply the formula to the rest of the rows.

Tired of spending hours cleaning data or writing complex formulas? Here’s a smarter solution: SheetAI.app

Whether you're managing sales reports, crafting marketing content, or analyzing feedback, working in spreadsheets can be time-consuming and repetitive. But what if you could automate these tasks and enhance your productivity directly within Google Sheets? That's exactly what SheetAI offers.

SheetAI is an AI-powered add-on for Google Sheets that brings advanced capabilities right into your spreadsheet. Simply describe what you want in plain English, and SheetAI will execute tasks such as generating formulas, cleaning data, summarizing text, and even creating images. (SheetAI Documentation - AI-Powered Functions for Google Sheets)

Here’s what you’ll love about SheetAI:

Natural Language Commands: Use plain English to perform complex tasks.

AI-Powered Functions: Leverage functions like =SHEETAI() and =SHEETAI_RANGE() for dynamic content generation.

Data Cleaning & Analysis: Automate data sanitization, summarization, and categorization.

Content Generation: Create blog ideas, product descriptions, and personalized messages effortlessly.

Image Creation: Generate images directly within your spreadsheet using =SHEETAI_IMAGE().

Formula Generation: Convert textual descriptions into accurate Google Sheets formulas.

Integration with AI Models: Supports GPT-3, GPT-4, Claude, and Gemini for versatile AI capabilities.

Perfect for marketers, analysts, educators, and anyone looking to enhance their spreadsheet workflows.

Ready to revolutionize your Google Sheets experience? Install SheetAI now and start automating your tasks with AI!

Method 2: Using `CONCATENATE`

Click on a new column and enter:

Press Enter and drag down the formula to fill other rows.

Method 3: Using `TEXTJOIN` (best for ignoring blanks)

Use the formula:

TEXTJOIN will skip empty cells automatically if you choose TRUE for ignore_empty.

Conclusion

Combining two columns in Google Sheets is quick and easy using simple formulas.

Whether you're managing names, product details, or any paired data, merging columns can help keep your sheet clean and organized.

With these methods, you can avoid manual work and ensure accuracy across large datasets. Practice using each method to find the one that suits your needs best.

FAQs can take you forward!

What if one of the cells is empty?

Use the TEXTJOIN function with TRUE to automatically skip empty cells.

Can I combine more than two columns?

Yes, all methods (&, CONCATENATE, TEXTJOIN) allow you to combine multiple columns.

Can I add punctuation between combined columns?

Absolutely! For example, =A2 & ", " & B2 adds a comma and space between values.

Will combining columns change my original data?

No, the original columns remain unchanged. The combined result appears in a new column.

How to Combine Two Columns in Google Sheets