回答編集履歴
1
利用する変数の修正
answer
CHANGED
|
@@ -7,9 +7,9 @@
|
|
|
7
7
|
```GAS
|
|
8
8
|
const B = 2
|
|
9
9
|
const D = 4
|
|
10
|
-
const ROWS = lastRow -
|
|
10
|
+
const ROWS = lastRow - topRow + 1
|
|
11
|
-
const merge = sheet.getRange(
|
|
11
|
+
const merge = sheet.getRange(topRow, B, ROWS, 2)
|
|
12
12
|
.getDisplayValues()
|
|
13
13
|
.map( v => [ v.join('') ] )
|
|
14
|
-
sheet.getRange(
|
|
14
|
+
sheet.getRange(topRow, D, ROWS).setValues(merge)
|
|
15
15
|
```
|