My apologies, I am very new to Google Sheets and spreadsheets in general. I'm trying to fill cells with repeated data and then analyze them. The data is extracted from another large worksheet and has a variable number of rows. Each cell has an associated date in another column, but sometimes that date is not filled in, I have to correct this as follows:

Demo

```
+ --- + --- + + --- + --- +
| 1 | a | | 1 | a |
+ --- + --- + + --- + --- +
| | b | | 1 | b |
+ --- + --- + + --- + --- +
| 2 | c | | 2 | c |
+ --- + --- + -> + --- + --- +
| | d | | 2 | d |
+ --- + --- + + --- + --- +
| | e | | 2 | e |
+ --- + --- + + --- + --- +
| 3 | f | | 3 | f |
+ --- + --- + + --- + --- +
```

j & # 39; uses `calculation matrix`

Elsewhere, which works very well for repeating formulas, but I can not make it work. The number of repetitions is stored in a cell and referenced if necessary. Currently, my solution is to copy my formula in thousands of lines, but I would prefer that the formula be in a cell and the rest be automatic.

My formula:

```
= INDEX (C: C, MAX (FILTER (ROW (OFFSET, 1 $, 0, 0, ROW ()))),
ISNUMBER (OFFSET (1 $, 0, 0, ROW ())))), 1)
```

The formula is exactly the same for each cell. I have therefore tried to wrap it in one if the number of executions is correct, but the formula is only evaluated once.

```
= ARRAYFORMULA (IF (OFFSET (C2, 0, 0, A2)) + 1, INDEX (C: C,
MAX (FILTER (ROW (OFFSET (C $ 1, 0, 0, ROW))),
ISNUMBER (OFFSET (1 $, 0, 0, ROW ())))), 1), "error"))
```

Is it possible to do this with one formula per column?