Concatenate data from multiple columns, rows, or cells Show
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
With Merge Values you will
How to merge cells 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 Merge cells in Google Sheetsin 3 different ways
Merge data in each column. Merge cells in each row. Merge all records from the selected range into one cell. License benefitsOur customers getUnconditional
Free support Volume discounts: the more you buy, the less you pay These companies choose Ablebits productsFrequently asked questionsWhat is Merge Values and what do I need it for?The add-on shows its best when you want to bring text parts together. If you have names and addresses or any other data in different cells, joining two columns or rows into one will take seconds with this tool. Doesn't Google provide a free way to merge cells?It does. But, alas, it preserves only the top-leftmost value erasing other records within the range. You can always turn for help to the CONCATENATE function to bring the text together. But you'll have to create the formulas for each row and column that you want to join. With our add-on, you won't lose any information and save time on entering endless formulas. How to merge cells in Google Sheets without losing the data?Find Merge values in the Merge & Combine group in Power Tools and follow these steps:
See a more detailed description here. My data has blank cells, but I don't need to combine them with the rest of data. Can I do that with your add-on?Of course. Simply check the option to Skip empty cells, and they will be ignored. I'm trying to bring lots of data to one cell, but the records won't fit.Make sure to select the additional option: Wrap text. Then each new record will be placed from a new line within the same cell. Can I revert the changes made with your add-on?Yes, the standard Google Sheets options will help. Either press Ctrl+Z on your keyboard or go to Edit > Undo in the Google Sheets menu. You can always pick the previous spreadsheet version from the Version history as well. Choose your planSystem requirementsOperating Systems
Browsers
Can you merge cells in Google Sheets and keep all data?Merge values in Google Sheets. 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.
Can I merge two cells and keep both data?With the Merge Cells add-in, you can combine data from several cells using any separator you like (e.g. space, comma, carriage return or line break). You can join values row by row, column by column or merge data from the selected cells into one without losing it.
How do you merge cells with the same data?Merge cells
Click the first cell and press Shift while you click the last cell in the range you want to merge. Important: Make sure only one of the cells in the range has data. Click Home > Merge & Center.
|