Ablebits
•  158,333
Overview
Combine columns, rows, or ranges of data and preserve original values.
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
Language:
Sort by:
A User of Merge Values
May 7, 2020
The add on was a life saver for combining over 3000 rows. My only request is to allow the option of no space when combining, as the sheets I work with often have breaks in the middle of words due to character length so I still have to go through and find those spaces to delete them. Other than that I loved using this! Thank you!
Is this review helpful?
Yes
No
A user of Merge Values
May 8, 2020
Thank you for your lovely feedback! If your cells with data contain extra spaces, you need a special tool to get rid of them. We already have such add-on but it's not part of Merge Values. Please search for Power Tools in the G Suite Marketplace, open the Remove group there > Remove spaces add-on. It will delete excess / leading and trailing / all spaces (depending on what you choose) in the selected cells at once so you won't have to do that manually.
Anubhav Narula
April 29, 2020
Useful
Is this review helpful?
Yes
No
Michael Sprabary
April 17, 2020
Worked excellent to merge columns. Great Tool
Is this review helpful?
Yes
No
A User of Merge Values
March 27, 2020
Amazing!!!!!! It makes my job soooo much faster!!! Thanks
Is this review helpful?
Yes
No
A User of Merge Values
February 29, 2020
doesn't work, the bloddy 'start' isn't there, and when i click on document add-ons, it appears on the sidebar with the 'Use' greyed out. bloddy joke.
Is this review helpful?
Yes
No
A user of Merge Values
March 2, 2020
Hello there, it's a common issue for all add-ons when you need to restart the page for the Start option to appear. As for the greyed-out button, please contact our support team (the Ablebits link at the top of the page > Support tab) with the details of the problem. We'll look into it.
A User of Merge Values
January 12, 2020
I have to try to do it SEVERAL times before it actually works.
Is this review helpful?
Yes
No
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...
Is this review helpful?
Yes
No
A User of Merge Values
November 4, 2019
Very useful tool, and helpful support team.
Is this review helpful?
Yes
No
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.
Is this review helpful?
Yes
No
A User of Merge Values
August 27, 2019
lmao 15 bucks a year
Is this review helpful?
Yes
No
1-10 of 24
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu