This is my table
...A............
1 1
2
3
4
5 9
I know the minimum value (A1=1) and I know the maxiumum value (A5=9). Now I want to fill the rows in between with the numbers leading up to the maximum value.
So it looks like this:
...A............
1 1
2 3
3 5
4 7
5 9
How can I do this in iWork Numbers? (maybe its the same as in Excel?)