Skip to content

Instantly share code, notes, and snippets.

@lutfiihsan

lutfiihsan/Combine Multiple Sheet

Forked from mhawksey/gist:2252211
Created April 10, 2020 01:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lutfiihsan/7fbc3b3b6c814900d8538fd03d4acdb7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lutfiihsan/7fbc3b3b6c814900d8538fd03d4acdb7 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. lutfiihsan renamed this gist Apr 10, 2020. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.js → Combine Multiple Sheet
    View file
    File renamed without changes.
  2. @mhawksey mhawksey created this gist Mar 30, 2012.
    15 changes: 15 additions & 0 deletions gistfile1.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    function combineData(){
    var doc = SpreadsheetApp.getActiveSpreadsheet();
    var sheets = doc.getSheets(); // get all the sheets
    var outSheet = doc.getSheetByName("combined"); // set where we want to write the results
    for (i in sheets){ // loop across all the sheets
    if (sheets[i].getSheetName().substring(0,9) == "followers"){ // if sheetname starts with 'follower' then
    var target = sheets[i].getSheetName().substring(12); // extract users name for target column
    var data = getRowsData(sheets[i]); // get extisting data from current sheet
    for (j in data){
    data[j]["target"] = target; // create a target column with the users name
    }
    insertData(outSheet, data); // insert data in 'combined' sheet
    }
    }
    }