let sheet = workbook.getActiveWorksheet(); // Insert at range G:G on selectedSheet, move existing cells right let range = selectedSheet.getUsedRange(); let rowCount = range.getRowCount(); // Set range G2 on selectedSheet sheet.getRange("G2").setFormulaLocal("=CONCAT(H2,\" \", I2)"); // Auto fill range sheet.getRange("G2").autoFill("G2:G"+rowCount, ExcelScript.AutoFillType.fillDefault); sheet.getRange("G2").copyFrom(sheet.getRange("G2:G1048576"), ExcelScript.RangeCopyType.values, false, false); sheet.getRange("G:G").getFormat().autofitColumns();