Filling in data gaps

I am trying to fill in gaps of data with linear averages.

So far instance I have 1 in E1 and 8 in L1. I would assume F1 to have 2 in it, G1 to have 3, H1 = 4, I1 = 5, J1 = 6 and K1 = 7.

Is there a certain analysis tool or formula/function to achieve this? Sorry for the terrible explanation, I'm having a hard time putting it into words.

Thanks.

Hi hoffey,

try this in F1 and copy right

=E1+($L$1-$E$1)/COLUMNS($E$1:$K$1)