Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Name | n | rate
- Term1 | 3 | 2.79
- Term2 | 4 | 3.00
- Term3 | 2 | 2.59
- Name | Seq
- Term1 | 1
- Term1 | 2
- Term1 | 3
- Term2 | 1
- Term2 | 2
- Term2 | 3
- Term2 | 4
- Term3 | 1
- Term3 | 2
- function myFunction() {
- var s = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
- var target = SpreadsheetApp.getActiveSpreadsheet().getSheets()[1];
- var vals = s.getRange("A2:B").getValues();
- for (var i = 0; i < vals.length; i++) {
- for (var j = 0; j < vals[i][1]; j++) {
- target.appendRow([vals[i][0], j]);
- }
- }
- }
Add Comment
Please, Sign In to add comment