google-spreadsheet Using arrays in Google Sheets Append column with row numbering
Example
A1:A4 have A,B,C,D.
B1 have the following formula:
=ARRAYFORMULA({A1:A4,ROW(A1:A4)})
Result
| A | B | C | |
|---|---|---|---|
| 1 | A | A | 1 |
| 2 | B | B | 2 |
| 3 | C | C | 3 |
| 4 | D | D | 4 |
A1:A4 have A,B,C,D.
B1 have the following formula:
=ARRAYFORMULA({A1:A4,ROW(A1:A4)})
Result
| A | B | C | |
|---|---|---|---|
| 1 | A | A | 1 |
| 2 | B | B | 2 |
| 3 | C | C | 3 |
| 4 | D | D | 4 |
