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.

Merge Values - Start

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
 
 

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite 2018.3 Summer Offer
 
 
Excel add-ins and Outlook tools - Ablebits.com