Help & Support
Send Feedback
Merge Values
Combine columns, rows, or ranges of data and preserve original values.
46,514 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
January 12, 2020
I have to try to do it SEVERAL times before it actually works.
Submit reply
Cancel
A user of Merge Values
January 13, 2020
Hello, could you please specify if it's the interface that got you confused or the add-on didn't work at all? We'd appreciate if you email our support team with the detailed description of the issue so we could investigate it.
A User of Merge Values
January 8, 2020
This is a 30 day trial, you have to pay $10 per year to use this...
Submit reply
Cancel
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
1-10 of 19
Additional information
Search
Clear search
Close search
Google apps
Main menu