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.Try it for 30 days for free
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.
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.
Find Merge values in the Merge & Combine group in Power Tools and follow these steps:
See a more detailed description here.
Of course. Simply check the option to Skip empty cells, and they will be ignored.
Make sure to select the additional option: Wrap text. Then each new record will be placed from a new line within the same cell.
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.