Replace NaN with next good value in a certain column of a table

I have T2.mat which is a table with 12 columns. I want to replace NaN in columns 5:7 (5 to 7) by exactly the next good value in each column. I don't want to replace NaN in other columns.

I searched a lot and tried hard to do this. I was read the question in the link below:

https://www.mathworks.com/matlabcentral/answers/337273-how-can-i-replace-nan-elements-with-the-nearest-value-in-the-same-column

but I want to do this in just columns 5 to 7 and not for rest of the columns. I attached T2.mat if it's help

Does anyone know how I can do this?

Thank you,

Behzad

Answer 1

[Guillaume]

It's as simple as:

T2 = fillmissing(T2, 'next', 'DataVariables', {'lat', 'lon', 'station_elevation'})

or

T2 = fillmissing(T2, 'next', 'DataVariables', 5:7)

I recommend the first expression as it is clearer as to which variable is to be filled (and will work even if the order of the columns changes).

[BN]

Works perfectly! Thank you so much. you really help me.