How to Combine Two Columns in Google Sheets | Scribe

    How to Combine Two Columns in Google Sheets

    • Alai Umerez |
    • 8 steps |
    • 14 seconds

      How to Combine Horizontally Two Columns in Google Sheets

      1
      Choose an empty column in your spreadsheet where you would like the combined results to be displayed Make sure this column does not contain any existing data to avoid overwriting or losing information
      2
      At the top of the Google Sheets interface, locate the menu bar and look for the Merge Cells icon, which is typically represented by a small grid with an arrow Once you find it, click on the small drop-down arrow next to the icon to reveal the available merge options
      3
      Select the option "Merge vertically"
      4
      Review the resulting data in the newly merged column Verify that the combined values appear as expected

      How to Combine Vertically Two Columns in Google Sheets

      5
      Select the columns you would like to merge
      6
      At the top of the Google Sheets interface, locate the menu bar and look for the Merge Cells icon, which is typically represented by a small grid with an arrow Once you find it, click on the small drop-down arrow next to the icon to reveal the available merge options
      7
      Select the option "Merge horizontally"
      8
      Review the resulting data in the newly merged column Verify that the combined values appear as expected