This add-on will become your best assistant for merging values in both adjacent & non-adjacent cells. 3 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.

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.10 (20 Apr 2022) *****
Improved: 
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- Minor UX and UI improvements.

Fixed:
- Errored if you selected the entire sheet by clicking a gray rectangle between rows & columns.
- Cleared values from cells if merging all cells into one was impossible due to intersecting an existing filter.

***** V1.9 (6 Oct 2021) ***** 
Improved:
- Significant performance improvements in processing large amounts of data.
- Now knows how to process up to 5,000,000 cells.
- Minor UX improvements.

Fixed: 
- Continued to work endlessly after showing the message about the empty selected range.
- Incorrectly merged data in each row from multiple ranges.

***** V1.8 (5 May 2021) *****
Improved:
- You can now merge cells not only from neighboring 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.