How to get monthly average

I have data (47 * 1)for 26 months starting in 2015 ending in 2107 as the Xlsx file

 Some months it has 3 values and some are 2 or1
I want to get average values for each month as new-data(26*1).
Any suggestion, to help me?

Answer 1

[dpb]

t=readtable('month.xlsx');
t=table2timetable(t);
mn=retime(t.Var1,'monthly',@mean);

I didn't download the file so if there are variable names for Var1 use whatever the variable is.

[b.m.n n]

thank you dpb this file looks like the pic

[dpb]

So did you try it? Looks like it would work "out of the box".