Merge Values for Google Sheets

How to work with Merge Values

Get the add-on

This simple add-on will help you combine values in rows, columns, or a group of cells in your Google sheet by following the steps described below.

Select cells with the values you want to join

First select the range with the entries you'd like to merge.

Open the Add-ons menu, select Merge Values and click Start next to it to see the add-on sidebar.

You can change the records to be combined any time before you click the Merge button, simply select the cells with the necessary values in your sheet.

Choose the merge option

You can merge the records within rows, columns, or combine all values from the selected cells.

Please choose the way you want to join them in the 'Choose how to merge the selected values' drop-down list.

Choose how you'd like to combine values in the Choose how to merge values field

Merge values within rows

Please select the 'in each selected row' option to get values on each line combined into one cell.

You can pick one of standard delimiters to use for the merged entries, or enter your own in the 'Separate values with' field.

Use the 'Place the results in the' drop-down list to choose destination for the merged values. You can place the merge results into the left or into the right cell on each row

Select In each selected row to merge values within each line

Merge values within columns

Select the 'in each selected column' option to get records within each of the selected columns pulled into one cell.

You can pick one of standard delimiters to use for the merged entries, or enter your own in the 'Separate values with' field.

You can enter any combination of characters for a delimiter

Use the 'Place the results in the' drop-down list to choose destination for the merge results. You can put the merged values into the top or bottom cell in each column.

Select In each selected column to merge values within each column

Merge the selected values into one cell

Please select 'into one cell' to get all the selected records in one cell.

You can pick one of standard delimiters to use for the merged values, or enter your own in the 'Separate values with' field.

Use the 'Place the results in the' drop-down list to define where you prefer the joined records to appear. You can place the merge results into the top-left, top-right, bottom-left or bottom-right corner of the selected range.

Select Into one cell to join all values into one

Pick additional options

There are 6 more helpful options you can use when merging values in your sheet.

Choose to Insert new row/column with the results to add additional cells with the joined values next to your original data. This option is available when you combine values in rows or columns. After you select where to place the results, you get the option to insert a column with the results left or right of the table you have when merging values in rows. When you merge column entries, you can insert a row with the results above or below, respectively.

Choose to Clear the contents of selected cells to remove all values that were merged from the source cells.

If you want to join all the selected cells into one area, make sure you select the Merge all areas in the selection check box.

If there are blank cells in the selected range, you can choose to ignore them by ticking the Skip empty cells check box and avoid excess delimiters in the results.

When you expect to get large values in the resulting cells, pick the Wrap text option.

Fine tune your merge options

Click "Merge"

Once you choose how to merge values and define the settings, click on the Merge button to see the combined results in your sheet.

Click Merge to combine the selected cells according to your settings

You will get the values joined according to the selected settings.

Find the values merged according to your settings

If you have any questions or difficulties with the add-on, please use the form below to let us know. We'll do our best to assist you.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our forum
 

Please remember that we work from 8am to 4pm GMT, this is 4:00am to 12:00pm EST,
1:00am to 9:00am PST, and our public holidays may differ from yours.

50+ professional tools for Excel to do your daily work
 
 
50+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard