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 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:
- 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.
Related pages
Responses
I have an existing google sheet...I added the addon, but the "addon" column is not appearing in my existing google sheet, only in new google sheets. I have a TON of data in this other sheet, so copying/pasting is freezing up. Any suggestions?
Hello David,
Thank you for your message. I have just replied to you by email.
Hello,
It would be really nice to have the option to combine without a comma, semicolon, space etc. I need to be able to combine columns into single logins with no delimiter.
Hello Jennifer,
This is possible, please simply delete a delimiter in the Separate values with field leaving it blank. Hope it will work for you.
Does this add-on give YOU access to my data?
Hello Curious,
Thank you for contacting us and for your interest in our products.
We do not collect, store, or share your personal data or information from your files. Please check our Privacy Policy for more details:
https://www.ablebits.com/docs/ablebits-privacy-policy/
You can also check the article that explains how our add-ons process your data:
https://www.ablebits.com/docs/ablebits-personal-data-safety/#use-google-add-ons
No option to click "start," only option is to click "help."
Hello William,
Please try to reload the spreadsheet and see if the option to run the tool appears in the menu. If this doesn't help, then please email to support@ablebits.com and specify what browser and operating system you use. Thank you.
Hi, I'm looking to merge sets of values in column B that correspond to one value in column A, that are separated by a blank cell. Essentially multiple merges separated by a blank cell.
For example, Name1 (A1) = job (B1), company (B2) ; Name(2)=job (B3), company (B4) etc.
Hi David,
Thank you for contacting us. For us to be able to help you better, please share a small sample spreadsheet with us (support@4-bits.com) with 2 sheets: a copy of your source data and the result you expect to get. I kindly ask you to shorten the tables to 10-20 rows. When sharing, make sure the option 'Notify people' is checked. I'll do my best to assist.
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.
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.
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?
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.
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?
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.
I am merging currency values how do i change from $ sign to £ sign - the cells are formatted in Google as £.
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.
Why is the "insert new column with results" option gone?
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. 🙂
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.
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.
hi - is it possible to upgrade from "merge values" to "power tools?"
thanks!
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.