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
How to use Merge Values
Start Merge Values
First, select the range(s) with the entries you'd like to merge.
Tip. You will be able to choose other records to combine any time before you click the Merge button. Simply highlight other cells with the necessary values in your sheet.
Then, open the Extensions menu, find Merge Values and click Start next to it to see the add-on sidebar:
You can also find Merge Values in the Merge & Combine
group in the Power Tools
Combine values in rows, columns, cells
You can merge the records within rows, columns, or combine all values from the selected cells:
- 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:
- 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.
- 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.
- 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.