Google Sheets - Auto-Generate sheets named with a cell value in a row and populated with remaining row data -


i'm trying use google sheets script editor create set of sheets form create individual sheets named after value of each cell in column "b" , populated data in rows 1 , x, x value of row each sheet.

what have far is:

function makesheets() {  var ss = spreadsheetapp.getactive(); var sheets = ss.getsheets(); sheets[0].getrange('b2:b100')     .getvalues()     .foreach(function (el, i) {         if (el[0] && !ss.getsheetbyname(el[0])) ss.insertsheet(el[0], sheets.length +i)     }); } 

this create new sheets same header rows (row 1) 1 new sheets. don't understand x want create.

function makesheets() { var ss = spreadsheetapp.getactive(); var sheets = ss.getsheets(); var r1=sheets[0].getrange('1:1').getvalues() sheets[0].getrange('b2:b100')     .getvalues()     .foreach(function (el, i) {         if (el[0] && !ss.getsheetbyname(el[0])) ss.insertsheet(el[0],   sheets.length +i).getrange('1:1').setvalues(r1);     }); } 

Comments