Hi
I have data in columns A - C and the number 1 in cell D1.
Does anyone know how I can drag the numbers from cell D1 to the rest of the column D (up to the last row of the data in column A) in consecutive order?
So my data would initially look like this:
However, I would like it to look like the table below (NB - the number of rows will vary, so the drag would have to be dynamic rather than fixed). TIA.
I have data in columns A - C and the number 1 in cell D1.
Does anyone know how I can drag the numbers from cell D1 to the rest of the column D (up to the last row of the data in column A) in consecutive order?
So my data would initially look like this:
| A | D | G | 1 |
| B | E | H | |
| C | F | I |
However, I would like it to look like the table below (NB - the number of rows will vary, so the drag would have to be dynamic rather than fixed). TIA.
| A | D | G | 1 |
| B | E | H | 2 |
| C | F | I | 3 |
