How to concatenate ranges in Google spreadsheets Sometimes it is necessary to concat ranges in Google Spreadsheet. Eg, Data 1 and Data 2 Sheet Data 1 Name Date Sum Ethan 3/4/2017 31