Is there a way to move numbers from cells in a column and put those numbers in
cells in rows , than average those cells per row ? eg:

a b c d e
f g h
1 cool 20 move to c1 20 15 7 7 1
average 10
2 cool 15 move to d1
3 cool 7 move to e1
4 cool 7 move to f1
5 cool 1 move to g1
6 tropic 5 move to c6 5 9
average 7
7 tropic 9 move to d6
8 gears 15 move to c8 15 12 6
average 11
9 gears 12 move to d8
10 gears 6 move to e8
11 heat 7 move to c11 7
average 7
12 top 6 move to c12 6 12
average 9
13 top 12 move to d12
down to 1020 rows

column "a" duplicate entries are at random sequences from 1 to 10 entries

all your efforts will be much appreciated
thank you for your time



bill gras