Merge values in Google Sheets

Concatenate data from multiple columns, rows, or cells

This add-on lets you quickly join values in each row, combine multiple columns in Google Sheets into one column, and merge cells in the selected range without losing your data. Unlike the standard option, the tool allows you to keep your table structure intact and insert resulting records to other cells of your sheet.

Try it for 30 days for free
Merge Values in Google Sheets

With Merge Values you will

  • Merge columns in Google Sheets into one Join text from multiple columns: merge values horizontally.
  • Combine necessary cells of data together Concatenate records from the selected range into one cell.
  • Determine a place for results Get the results in a new row or extra column, or add them to the selected cells.
  • Wrap text in the resulting cells For when you combine bunch of records into one cell.
  • Bring values from several rows into one Merge data vertically.
  • Use any delimiter to separate merged entries Take advantage of standard separators or enter your own ones.
  • Keep or remove source values Save original records to merge cells without losing the data or choose to clear them altogether.
  • Skip empty cells Ignore any blanks you have in the range.

How to merge cells in Google Sheets

   
Video: How to merge values in Google Sheets
Find the add-on in Power Tools
Find the add-on in Power Tools
Concatenate values in each selected row and separate them with spaces
Concatenate values in each selected row and separate them with spaces
Combine first and last names in Google Sheets
Combine first and last names in Google Sheets
Join data vertically dividing with line breaks
Join data vertically dividing with line breaks
Merge values in each selected column and place them to the top cell
Merge values in each selected column and place them to the top cell
Choose to merge all selected values into one cell
Choose to merge all selected values into one cell
Have the records wrapped one under another
Have the records wrapped one under another
Video: How to merge values in Google Sheets
Find the add-on in Power Tools
Concatenate values in each selected row and separate them with spaces
Combine first and last names in Google Sheets
Join data vertically dividing with line breaks
Merge values in each selected column and place them to the top cell
Choose to merge all selected values into one cell
Have the records wrapped one under another

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Volume discounts: the more you buy, the less you pay
Free support

These companies choose Ablebits products

   

Frequently asked questions

About Merge Values for Google spreadsheet

Choose your plan

12-months

  • 12-month access with all updates
$15.00
Buy now

Lifetime

  • Get all new features and updates for free ever!
$39.95
Buy now

System requirements

Operating Systems

  • Microsoft: Windows 7 and up
  • Mac: Yosemite 10.10 and up
  • Chrome OS™

Browsers

  • Chrome™
  • Firefox
  • Safari (Mac only)

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close