Merge Values is an add-on that you can use on Google Sheets. This is great when you have items in columns in a spreadsheet where you would like them to merge into one cell. The concatenate formula I have used in the past allows you to do this, but I have had to maintain the data in the cells being combined or use extra steps to extract the combined cells. For example, I create spreadsheets with student names and user IDs on them. Their Google apps account requires the email address, so I need to append @schooldomain.com to each student's user id. Merge Values allows me to do this very easily.
After I installed the Add-on, I created a spreadsheet with the names and User Ids. Then I created a column with @schooldomain.com down the entire column. When I started the Merge Values Add-on, a sidebar appeared with various options:
After I installed the Add-on, I created a spreadsheet with the names and User Ids. Then I created a column with @schooldomain.com down the entire column. When I started the Merge Values Add-on, a sidebar appeared with various options:
There is a variety of options, but by clearing the contents of the selected cells and deleting options to separate the values, I was able to create the student IDs as email addresses much more quickly than I had in the past.
If you would find it useful to merge data from cells in a spreadsheet, open a new spreadsheet, go to Add-ons, go to Get Add-Ons, and install the Merge Values add on.
If you would find it useful to merge data from cells in a spreadsheet, open a new spreadsheet, go to Add-ons, go to Get Add-Ons, and install the Merge Values add on.