How to fill in gaps with reasonable values

Hi Guys, Please find attached my .xlsx file, the data in column 1 of my Excel file has different number of gaps (i.e 1 gap, 2 gaps, 3 gaps, 5 gaps, 6 gaps). I need help in filling the gaps with reasonable values. So, when I'm reading the Excel file on Matlab, the missing gaps become "NaN". My question is if there's a way to fill in the cells only when the number of gaps is <= 5. And just ignore those if the number of gaps is >5?

Answer 1

[Image Analyst]

If you have the Image Processing Toolbox, you can use regionfill().