How can I merge multiple tabs in a Google Spreadsheet using Google App Script?

by

=query({Sheet1!A1:C; Sheet2!A1:C; Sheet3!A1:C}, "where Col1 is not null", 0)

I wouldn’t use a script for this; the worksheet formulas are much faster, at least most of the time.
Make sure you use semicolons to separate the ranges. Semicolons are the End_Of_Row operator for array literals.

If you really want to use a script…

function combineSheets() {
  var sApp = SpreadsheetApp.getActiveSpreadsheet();
  var s1= sApp.getSheetByName("Sheet1");
  var s2= sApp.getSheetByName("Sheet2");
  var s3= sApp.getSheetByName("Sheet3");
  var s4= sApp.getSheetByName("Sheet4");
  //  If Sheet4 doesn't exist you'll need to create it here.
  
  var s1values = s1.getRange(1,1,s1.getLastRow(),3).getValues();
  var s2values = s2.getRange(1,1,s2.getLastRow(),3).getValues();
  var s3values = s3.getRange(1,1,s3.getLastRow(),3).getValues();
  
  //  Now, we can put out all together and stuff it in Sheet4
  var s4values = [];
  s4values =  s1values.concat(s2values,s3values);
  s4.getRange(1,1,s4values.length,3).setValues(s4values);
}

More Related Contents:

  1. Determining the last row in a single column
  2. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  3. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  4. Google Sheets OnEdit() – You do not have permission to call a service
  5. Detect user inserting row or column in a google spreadsheet and reacting in a script
  6. How to define global variable in Google Apps Script
  7. Periodically refresh IMPORTXML() spreadsheet function
  8. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  9. Format a Google Sheets cell in plaintext via Apps Script
  10. Moving Files In Google Drive Using Google Script
  11. How to get onFormSubmit to trigger automatically?
  12. Copying a spreadsheet copies all linked files as well
  13. onEdit simple trigger never seems to be triggered
  14. “SpreadsheetApp.getUi() cannot be called from this context”
  15. Using built-in spreadsheet functions in a script
  16. Protect ranges with google apps script
  17. How to access new ‘in-cell-image’ from google apps script?
  18. How to convert a Google Sheets-File to an Excel-File (XLSX)
  19. Dynamically creating spreadsheet menu items
  20. Creating and Sending sheets in the same function
  21. How do I know if spreadsheet cells are merged using google apps script
  22. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  23. How to ignore empty cell values for getRange().getValues()
  24. Google apps script error: “You do not have permission to call protect” [duplicate]
  25. Use script in all spreadsheets
  26. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment