Merge cells without deleting data in Google Sheets

Whenever you find records that belong together, use this simple add-on to quickly join values in rows, columns, or the entire range. Get Merge Values from the Google Sheets store:
https://workspace.google.com/marketplace/app/merge_values/857144221591

Or get a direct link to the add-on on our website:
https://www.ablebits.com/google-sheets-add-ons/merge-values/index.php

00:01 Introduction to Merge Values
00:13 Start Merge Values
00:23 Merge values within each row
01:54 Merge values withing columns
02:25 Merge an entire range of cells together
02:53 Wrap-up

👋 Let's be friends on socials!
LinkedIn: https://linkedin.com/company/apps4gs/
Facebook: https://www.facebook.com/ablebits/

#merge #googlesheets #spreadsheet #ablebits

---

Closed Caption:

when you need to join data in your
spreadsheet there are generally two ways
you can go formulas for bringing values
together and the merge tool for
combining
cells this add-on lets you quickly do
both without losing any
data once you start the tool there are
three simple settings to
choose first decide in what direction
you want to join the selected
records say here I want to combine name
within each row so I'll pick the option
in each selected
row then pick the delimeter for the
values a simple space will be good here
but you can enter any combination of
characters in this
field you can also leave it blank in
case you want to attach values from the
cells without any
separators then choose where to place
the results when joining values in rows
you can put them into the left or or to
the right cell in the selected
range however there is also an
additional option that lets you add a
new column with the results to the left
or to the right of your data
respectively there are a few other
options that make the process
flexible you can keep or delete the
source values from the selected columns
after you get the concatenated
value combine the cells together with
all the data and avoid the standard
warning
skip blanks in your
range wrap text in the resulting
cells this can be especially useful if
you select a line break as a
delimiter and create a backup copy of
your sheet if
necessary click merge and get the
results right
away if you would like to match values
within columns
instead for example this table requires
joining the order details together we
will change the first setting to merge
values in each selected column I will
also change the delimeter to a line
break place the results at the top
insert the row above and W
text click matage and get the values in
one
cell let me also show you how you can
quickly merge an entire range of cells
together and preserve all your
records first we combine the values into
one
cell separate them with a semicolon and
the line
break and merge all selected cells into
one click merge and get all your data in
one cell that you can unmerge using the
standard option in Google
Sheets please note that you can get the
latest version of this add-on with power
tools feel free to post your questions
in our community or email us right from
the add-on we'll do our best to help you