gap filling with liner interpolation

Hi,

I have a data file (attached) which I need to fill gaps (here in -9999) by liner interpolation. Could anyone please help me with this.

Many thanks

[KALYAN ACHARJYA]

B Column?

[Matt J]

Getting answers in the forum is generally more efficient if you attach attach relevant variables in a .mat file, rather than in .xlsx format.

Answer 1

[Matt J]

A=xlsread('data.xlsx'); 

I=A==-9999; 
J=find(~I); 
B=A; 


B(I)=interp1(J,A(J),find(I));

[Binu]

Thanks Matt.It worked very well