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

How to use Merge Values

Start Merge Values

First, select the range 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 Add-ons menu, find Merge Values, and click Start next to it to see the add-on sidebar:
Merge Cells icon on the Ablebits Data tab.

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

  1. Access the Merge & Combine group from the corresponding Google Sheets menu:
    Open the necessary group in Power Tools.
  2. Click the Merge values icon on the Power Tools sidebar:
    Run Merge Values directly from Power Tools.

Combine values in rows, columns, cells

You can merge the records within rows, columns, or combine all values from the selected cells:
Fine-tune all the necessary options in the Merge Values sidebar.

  1. Choose how to merge the selected values:
    • in each selected row - get values on each line combined into one cell:
      Merge Values in each selected row.
    • in each selected column - get records within each column pulled into one cell:
      Merge Values in each selected column.
    • into one cell - get all the records in one cell:
      Merge Values into 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:
      Clear the contents of selected 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:
      Merge cells in each row.
    • 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.

Post a comment

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.