How to perform simple interpolation of excel data on matlab?

Hi All, I've attached an image of how my .xlsx file looks like so it would be easier to explain my scenario: As you can see from the .xlsx, there are two columns, in the second column, there are some "blank cells", my objective is to perform interpolation in order to fill in the blank cells. I understand that linear interpolation can be performed if the NGap=1, but I really need help with the interpolation when NGap=2, 3, 4, 5. Thank you very much for your kind assistance :)

Answer 1

[dpb]

x=xlsread('yourExcelFile');
idx=isnan(x(:,2));
x(idx,2)=interp1(x(~idx,1),x(~idx,2),x(idx,1));

doc xlsread
doc interp1 % for details

--