Assumed we have this table style in sheet 1:
A B C D E F G H
1 0.1 0.2 0.5 0.7 0.4 0.5 0.9 1.0
2
3
In sheet 2 there have to be averages made out of the paired cells of sheet 1, means averages from A1:B1, C1:D1, E1:F1, and so on.

AVERAGE(A1:B1) from sheet 1 should be in sheet 2: cell A1,

AVERAGE(C1:D1) from sheet 1 should be in sheet 2: cell B1,

AVERAGE(E1:F1) from sheet 1 should be in sheet 2: cell C1, and so on…
A B C D 1 0.15 0.6 0.45 0.95 2 3
My assumption was to simply use the OFFSETfunction with some command like that:
=OFFSET(AVERAGE(A1:B1),0,(COLUMN()1)*2))
As the rows do not get switched, we can put a 0 into the row move option.
Unfortunately, this command does not work as expected. Any ideas?