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 |