Merge values in Google Sheets

Title: Merge values in Google Sheets
Author: Ian
Created at: 2024-11-07 06:32:16
Updated at: 2024-11-12 17:03:16
Link: https://tools.techidaily.com/ablebits/google-sheets-add-ons-merge-values/
License: This work is licensed under <a class="license" target="_blank" rel="noopener" href="https://creativecommons.org/licenses/by-nc-sa/4.0">CC BY-NC-SA 4.0 .

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.

Buy license

Choose your plan

Download

Try it for free

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 a certain cell within the selected range.
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.