Hi,

I have a large amount of data that I require averaged between specific intervals, all 1m lengths.

An example of data is below:

A B
1.3 1
1.5 2
1.6 2
2 1
2.1 2
2.4 1
2.8 1
3.3 2
3.9 2


I want to display the results as:

From To Average
1 2 1.666666667
2 3 1.25
3 4 2

Any help would be greatly appreciated!