Data imputation across multiple columns

[oliverd]

How should I do a linear interpolation for the following example data:

so that I get the following result:

[Amol_Telore · Accepted solution]

Hey @oliverd 

Here is my solution. Feel free to reach out to me in case of any concerns.

FYI, I have pivoted data first so that we don't need to use Multi Row formula multiple times and you can have it for N number of fields.

[oliverd]

Very nice thank you