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.

Responses

Michael Matzdorff says:
November 8, 2018 at 6:02 am

hi - is it possible to upgrade from "merge values" to "power tools?"
thanks!

Reply

Hi, Michael,

Thank you for your question!

We've got your email in our support Inbox and already answered it.
If you have any other questions regarding your orders, please send them to our support email: support@ablebits.com.

Thank you.

Reply

Hello, how do you combine the columns but still keep the formatting in that cell? is that possible? I want to try and keep the colors of the fonts etc.

Reply

Hello, Sarah,

Thank you for your interest in our product!

I'm afraid the add-on works a bit differently - the formatting of the cell where you pull all the records to is applied to all the values.
I will forward your request to our developers, and they will check if it's technically possible to implement the feature. I can't give you any timing but can let you know if/when it's available.

Please accept my apologies for any inconvenience that may be caused to you by this.

Reply

Why is the "insert new column with results" option gone?

Reply

Hello, Tony,
Thank you for your question.

The option is not gone.
It's the first one in the list of options you can tick off. Please refer to point 4 of the instructions to find it. 🙂

Reply
Roger Pollard says:
November 21, 2018 at 4:21 pm

I am merging currency values how do i change from $ sign to £ sign - the cells are formatted in Google as £.

Reply

Hello, Roger,
Thank you for your question.

We were able to reproduce the problem on our side. Our developers will try and fix the issue as soon as possible.
Unfortunately, I can't give you any timing, but I can let you know when it's fixed.

I sincerely apologize for any inconvenience.

Reply
Matthew Smaldone says:
January 11, 2019 at 4:10 pm

I need to merge two similar rows into one row, rather than merging values within the same row. Do you have a power tool for that? Am I misunderstanding this power tool?

Reply

Thank you for your interest in our products, Matthew.

For me to be able to advise you better, please share a small sample spreadsheet with us (gapps.ablebits@gmail.com) with your source data and the result you expect to get. I kindly ask you to shorten the table to 10-20 rows.
I'll look into it and see if our software can help.

Thank you.

Reply

I need to merge several columns and have them separated by a comma. Some of the cells are empty, but I still need them to be represented by a comma when it's all merged and done. It used to do this automatically, but not it just skips over empty cells, even when the "skip empty cells" box isn't checked. Any ideas?

Reply

Thank you for reporting this problem to us, Peter.

We were able to reproduce the issue on our side for the "merge in each selected row" option. It looks like a bug and our developers are already working on fixing it.
I'm not sure how much time it will take, but if you'd like, I can email you when the fixed version is out.

Reply

I have Power Tools for Google Sheets. Using "merge values in each selected row", I want to merge a row of names with a row of addresses. How can I merge so that each cell has the name shown on top of the address? Thus, I want each cell to show the name on line 1 and the address on line 2 and 3 of the cells.

Reply

Thank you for choosing our product, Meagan.

We just replied to you by email. Please check your Spam/Trash/Junk folders if you don't see it in your Inbox.

Reply

Ask a question (posted publicly)

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.