I have a spread sheet with a lot of data. I would like to “shrink data” so that I would re-count data to average of 5 columns. Then amount of data would shrink to the one fifth.
I tried kind of next method:
Data to average would be in row2 and row1 is running count 1,2,3,4…
Fill this down until R1Cx*5 is number of the last data column.
This syntax does not work but is there simple method do this kind of calculation?