Hi,

I am trying to interpolate a data set to 1 second intervals. The original data set is unevenly spaced i.e. 1, 3, 5, 6, 8, 9 etc. I have attached an example data sheet.

Column A = Time (s)
Column B = Value

Column D = Interpolation Time Value (i.e. 1 s intervals)
Column E = Interpolated Value.

If you could provide an excel equation for column E it would be much appreciated. Please feel free to edit the spreadsheet layout if this makes it easier.

Interpolation Spreadsheet Example.xlsx

Many thanks,

Andy