App Icon
Combine columns, rows, or ranges of data and preserve original values.
Works with:
406,652
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. 

30 DAYS OF FREE USE

Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

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!

Merge Values is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:

***** V1.8 (5 May 2021) *****
Improved:
- You can now merge cells not only from neighbouring columns but from multiple non-adjacent ranges as well.
- Performance improvements in processing large amounts of data.
- Minor UX improvements.

Fixed:
- The 'Date' and 'Currency' number formats changed after the merge.
- Errored if your 'Data validation' rules prevented them from editing the cells.
- Didn't work if you run them from a sheet with its own separate chart.

***** V1.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.
Additional information
Privacy policy
Terms of service
Merge Values will ask for the permissions shown below. Learn more
Merge Values will need access to your Google account
This will allow Merge Values to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
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
Profile Picture
A User of Merge Values
March 12, 2018
I don't think it's fair that you can only use it once a day. Especially when it doesn't work the first time.
Is this review helpful?
Yes
No
Profile Picture
A User of Merge Values
November 16, 2015
Works like a charm. Easy to use and does exactly what I need. Saves me hours of time.
Is this review helpful?
Yes
No
Profile Picture
Jesse Nichols
April 11, 2014
It works as intended, but could you add a feature that allows you to replicate the "text-to-columns" feature in Excel? I want to be able to separate cells into distinct columns based on some identifying symbol such as a comma or tab.
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
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!
Is this review helpful?
Yes
No
Profile Picture
A User of Merge Values
April 4, 2018
Main sheet size is 15,000 rows, lookup is 150,000 rows and it seems to error out every time. I have had it work on smaller data sets so I gave it a 3.
Is this review helpful?
Yes
No
Profile Picture
A User of Merge Values
April 23, 2017
I like it a lot, very helpful. However is there a way to Merge cells and have them keep the format IE if i bold something and do the merge nothing will be bold after
Is this review helpful?
Yes
No
Profile Picture
A User of Merge Values
November 4, 2019
Very useful tool, and helpful support team.
Is this review helpful?
Yes
No
Profile Picture
A User of Merge Values
July 8, 2019
A few glitches but nothing major and works well for merging cells
Is this review helpful?
Yes
No
1-10 of 40
Search
Clear search
Close search
Google apps
Main menu