Interpolation between two values over a range

Hi,

I want to interpolate two values in Excel.

The first value is in cell "A1" and has the value "0". The second value is in cell "A20" and has the value "1".

I now want to interpolate the values in cells "A2" to "A19" in such a way that a linear straight line is created between the values "0" and "1".

The particular problem is that the cell numbers between "0" and "1" are not always the same size. Sometimes there are e.g. 10 cells between "0" and "1" and other times there are e.g. 25 cells between "0" and "1". Each interpolation has a different number of cells between the value "0" and the value "1".

Is it possible to create a formula that automatically takes into account the different numbers of cells between "0" and "1" and calculates the interpolation between "0" and "1"?

Many thanks for your help.