How to reduce data automatically by creating averages when certain increase is reached

I have a lot of excel data and want to reduce it by creating averages. My problem is I dont know how to do it automatically.
For example, I have 2 columns A and B. When the values in A reach an increase of 1, I want to calculate the average of all previos corresponding values in column B, until the last time the treshold was reached.
A sample file is added. I feel like I probably need some additional columns but I cant think of a good way on how to approach this.

Thanks for your help!

You can use this formula in cell C3 (there is no point in putting it in C2):

=IF(INT(A3)<>INT(A2),AVERAGE(INDEX(B:B,MATCH(INT(A2),A:A)+(INT(A2)>0)):INDEX(B:B,ROW()-1)),"")

Copy it down to the next row after your data.

This assumes that the first value in A is zero.

Hope this helps.

Pete

EDIT: you may have to use semicolons ( ; ) in the formula rather than commas ( , ) depending on your regional settings.

Pete

Glad to help, and thanks for the rep.

Pete