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.
First, select the range(s) with the entries you'd like to merge.
Then, open the Extensions menu, find Merge Values and click Start next to it to see the add-on sidebar:
You can merge the records within rows, columns, or combine all values from the selected cells:
Once the settings are defined, click Merge and you will get the values joined in your spreadsheet accordingly.
hello, when I press start merge values, an empty pop-up with "merge values" at the top appears but doesn't load so I can't merge anything, how can I fix this? thanks!
Thank you for your comment.
Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on and try to reproduce the issue. If it persists, please send the screenshot of an empty pop-up with “merge values” to firstname.lastname@example.org. Thank you.
How do i merge and center two cells in one column ?
Thank you for contacting us again. For us to be able to help you better, please share a small sample spreadsheet with us (email@example.com) with 2 sheets: (1) a copy of your source data (2) the result you expect to get (the result sheet is of great importance and often gives us a better understanding than any text description). I kindly ask you to shorten the tables to 10-20 rows. Thank you.
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?
Thank you for your message. I have just replied to you by email.
Hello, I am experiencing the same problem as David. Can you please provide me with the solution?
Thank you for your message. You need to check who is the owner of the spreadsheet you are having difficulties with. If it is you, please email us at firstname.lastname@example.org.
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.
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?
Thank you for contacting us and for your interest in our products.
You can also check the article that explains how our add-ons process your data:
No option to click "start," only option is to click "help."
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 email@example.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.
Thank you for contacting us. For us to be able to help you better, please share a small sample spreadsheet with us (firstname.lastname@example.org) 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 (email@example.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.
I am merging currency values how do i change from $ sign to £ sign - the cells are formatted in Google as £.
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?
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.
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?"
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: firstname.lastname@example.org.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!