Help & Support
Send Feedback
Merge Values
Combine columns, rows, or ranges of data and preserve original values.
40,160 users
Works with
Install
Overview
This add-on will become your best assistant for merging values in adjacent cells. Three simple settings let you decide if you want to combine multiple columns or rows, pick the delimiter for the records, and choose a place for the results. 
-	Join values horizontally, vertically, or bring all records from the selected range into one cell
-	Add results to the existing values or as a new column or row
-	Merge cells without losing your data: you can avoid the standard problem of “Keeping data only in the top leftmost cell” and retain all your records while removing borders between them
-	Skip blanks, wrap text, and choose other additional options that tailor the results to your needs.

Besides, there is a special option that creates a backup copy of your sheet in case you want to keep it the way it was. You can set up the process in under a minute and concatenate data in seconds. 

What's new?
Version 1.6:
- Improved UI.
- Minor bugs fixed.
- We introduced yearly subscriptions, you can still enjoy a fully-functional trial version of the add-on for 30 days.

If you have any questions about the add-on, please post them here: https://www.ablebits.com/docs/google-sheets-merge-values/
We'll be happy to assist!
Reviews
A User of Merge Values
November 4, 2019
Very useful tool, and helpful support team.
Submit reply
Cancel
A User of Merge Values
September 6, 2019
I've been using it for a the good part of this year 2019, and so far it hasn't failed me. And I'm generally very picky about what a tool /software /product should & should not do! That said, I've been using it for a specific purpose - to merge my Paypal and Venmo data into a more QuickBooks statements like format. So I'm happy (so far) because it does that job pretty well without errors and with significant ease of use.
Submit reply
Cancel
A User of Merge Values
August 27, 2019
lmao 15 bucks a year
Submit reply
Cancel
A User of Merge Values
July 8, 2019
A few glitches but nothing major and works well for merging cells
Submit reply
Cancel
A User of Merge Values
March 28, 2019
Very useful tool, I need it, but it is very slow at times, which then makes the task take longer than doing it manually. Please improve the speed!
Submit reply
Cancel
A User of Merge Values
January 25, 2019
ten bucks for a year to do one tiny function? Have you SEEN the cost of Office365?
Submit reply
Cancel
A User of Merge Values
January 9, 2019
not really useful, using function is easier
Submit reply
Cancel
A user of Merge Values
February 18, 2019
Waste of money.
A User of Merge Values
November 21, 2018
Had high hopes this would solve my problem of how to easily mail merge a table from Sheets into Google Docs but as I soon found out; all currencies default to being $ (I live in the UK,) and, dates are reformatted to US mm/dd/yyyy format and the time in EAT is added, plus, after it has merged the cell the cell size is increased to over double what it needs to be. The only work around i found was to copy and paste the cells I needed to merge (as values) then format the dates and currencies to text. then do the merge then use the Google menu item 'demerge cell' to restore each cell to a size appropriate to the data in it. At least I found all this out without having to pay but unless I am told I am not using the app correctly I am very unlikely to buy it.
Submit reply
Cancel
Nadja von Massow
October 7, 2018
Missing the option to "Separate values with:" nothing = no space, no semicolon. All combined. We're using this on rows of code generation, and the spaces between cells are what we were hoping to get rid of with your tool. No such luck.
Submit reply
Cancel
A user of Merge Values
October 8, 2018
Thank you very much for your feedback, Nadja. If you delete the delimiter offered by the add-on using your keyboard (Delete key), your records will be merged without any separators and spaces. :)
A User of Merge Values
September 10, 2018
Great add on and really efficient for when I need to use it. The fact that I can only use it once a day without the subscription is really annoying. This add-on should no be listed as free when it's really not.
Submit reply
Cancel
A user of Merge Values
September 26, 2018
Hello there, I'm really sorry for the inconvenience. Could you please specify where you saw that the add-on is free? You see, we put the info about the subscriptions everywhere we could. If you mean the "free" button you click when installing - this is merely Google button for all add-ons in sheets no matter their distribution policy. If we forgot to place the pricing info somewhere, please let us know so we could fix that. Thank you for your time!
1-10 of 17
Additional information
Search
Clear search
Close search
Google apps
Main menu