Merge Values Add On

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:

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.