How to Combine Two Columns in Google Sheets

Sanskar Tiwari

Author: Sanskar Tiwari

Founder at MagicSlides

Published

Easily combine two columns in Google Sheets using simple formulas like CONCATENATE, TEXTJOIN, or ampersand

How to Combine Two Columns in Google Sheets

Combining two columns in Google Sheets can help you create full names, merge data, or format lists neatly.
Whether you're working with first and last names or two separate data sets, merging columns is a valuable trick that saves time and reduces errors.
Google Sheets provides multiple easy ways to combine columns using formulas like CONCAT, TEXTJOIN, and the ampersand (&) operator.
This tutorial will walk you through each method step by step so you can choose the one that fits your needs and start combining data effortlessly.

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

Step 1: Open Your Google Sheet

  • Open your desired spreadsheet or create a new one.

Step 2: Identify the Columns to Combine

  • For example, Column A contains first names and Column B contains last names.

Step 3: Use the Ampersand (&) Operator

  • In a new column (say Column C), enter the following:
    • This combines the first and last name with a space in between.
    • Press Enter and drag the fill handle down to apply to other rows.

    Step 4: Use the CONCATENATE Function (Alternative)

    • In Column C, type:
      • Press Enter to get the combined result.

      Step 5: Use the TEXTJOIN Function (For More Flexibility)

      • For multiple columns or optional delimiters, use:
        • The TRUE argument ignores blank cells automatically.

        Conclusion

        Combining two columns in Google Sheets is fast and simple using formulas like &, CONCATENATE, or TEXTJOIN.
        These methods help you organize your data more efficiently, especially when preparing reports or lists.
        Once you get familiar with them, you'll save time and streamline your workflow with ease.

        FAQs cam come handy!

        What if one of the cells is blank?

        Use TEXTJOIN(" ", TRUE, A2, B2) to skip blank cells automatically.

        Can I combine more than two columns?

        Yes, TEXTJOIN works great for combining multiple columns at once.

        How do I add a comma between combined values?

        Use =A2 & ", " & B2 or TEXTJOIN(", ", TRUE, A2, B2).

        Can I replace the combined formula with values?

        Yes, copy the cells and use Paste special > Paste values only to replace formulas with static text.

        Share on socials