Merge multiple values into one in Google Sheets

The Merge Values add-on for Google Sheets combines data in multiple rows, columns, or a group of cells in your Google spreadsheet into one cell in a few quick steps.

• Video: How to merge values in Google Sheets
• Before you start
• How to use Merge Values
  • Start Merge Values
  • Combine values in rows, columns, cells
• Related pages

Before you start

The add-on cannot merge records from multiple ranges.

For example, if you press Ctrl to select multiple adjacent rows, the tool will process only the last one selected since Ctrl is used to highlight several different ranges in Google Sheets.

Thus, please make sure you select one data range with your mouse only.

How to use Merge Values

Start Merge Values

First, select the range with the entries you'd like to merge.

Then, open the Add-ons menu, find Merge Values, and click Start next to it to see the add-on sidebar:

Tip. You can also find Merge Values in the Merge & Combine group in the Power Tools add-on:

Combine values in rows, columns, cells

You can merge the records within rows, columns, or combine all values from the selected cells:

1. Choose how to merge the selected values:
   • in each selected row — get values on each line combined into one cell:
     
   • in each selected column — get records within each column pulled into one cell:
     
   • into one cell — get all the records in one cell:
     
2. Pick one of standard delimiters to use for the merged entries:
   • Space (⎵)
   • Semicolon (:)
   • Comma (,)
   • Line break (↲)
   Tip. You can enter your own delimiter/combination of delimiters in the Separate values with field or leave it blank to stitch the values together. The separators you enter manually are saved in the drop-down list for the next time you use the add-on.
3. Use the Place the results in the drop-down list to define where you prefer the joined records to appear:
   • Left cell or right cell of each row if you merge columns.
   • Top cell or bottom cell of each column when you combine rows.
   • Top-left corner, top-right corner, bottom-left corner, or bottom-right corner of the selected range when you bring all cells into one.
4. There are 5 more helpful options for you to merge values in your sheet:
   • Choose to Insert new row/column with the results to place additional cells with the joined values next to your original data.
     Note. This option is available when you combine values in rows or columns only. If you merge values in rows, you will be able to insert a column with the results to the left or right of the original data. When you merge column entries, you can insert a row with the results above or below respectively.
   • Tick off Clear the contents of selected cells to remove all values that were merged from the source cells:
     
   • If you want to join all the selected cells into one area, make sure to check the Merge cells in each row/column/selected range box:
     
   • When there are blank cells in the range to combine, you can ignore them with the Skip empty cells option. Thus you'll avoid excess delimiters in the results.
   • In case you expect to get large values in the resulting cells, pick the Wrap text option.

Once the settings are defined, click Merge and you will get the values joined in your spreadsheet accordingly.

Related pages

• Combine duplicate rows in Google Sheets
• Match and merge data from two Google spreadsheets
• Split text to columns — by characters and position