I've got a spreadsheet that looks like this in Libre Office Calc:
+-----------+
| | A |
| 1 | 444 |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| n | |
| n+1 | 938 |
+-----------+
A(1) < A(n+1), 444 and 938 are used as a matter of example.
Is there a way to automatically fill the cells between A(1) and A(n+1) with integer values (by repeating them if needed) ?
Expected result:
+-----------+ +-----------+
| | A | | | A |
| 1 | 444 | | 1 | 444 |
| 2 | | | 2 | 527 |
| 3 | | | 3 | 610 |
| 4 | | | 4 | 693 |
| 5 | | | 5 | 776 |
| 6 | | | 6 | 859 |
| 7 | 938 | | 7 | 938 |
+-----------+ +-----------+
Another example:
+-----------+ +-----------+
| | A | | | A |
| 1 | 5 | | 1 | 5 |
| 2 | | | 2 | 5 |
| 3 | | | 3 | 6 |
| 4 | | | 4 | 6 |
| 5 | | | 5 | 7 |
| 6 | | | 6 | 7 |
| 7 | 8 | | 7 | 8 |
+-----------+ +-----------+
Thank you.
=[previous cell]+83
to all open cells?