I recently lost a Basic program that I used to run on Excel spreadsheets to
create averages, and then insert a new blank line between the sets of data.
Each data grouping needs to be averaged.
Here is what it looks like:
Identifier Data 1 Data 2 Data 3 Data 4 Data 5 .... up to
max of Data 14
56902 1.2 3.5 22.6 12.2 26.6
56903 1.5 3.2 21.6 11.2 25.5
56904 1.6 3.0 22.5 10.2 22.4
Averages go here (under each data column) and blank line is inserted by
program to separate from next line.
56905 1.3 3.2 22.1 10.2 22.3
56906 1.2 3.1 22.0 11.2 23.5
56907 1.1 3.2 20.0 10.2 22.5
56908 1.0 3.2 20.3 11.2 22.6
56909 1.2 3.3 24.5 10.2 23.6
56910 1.0 3.5 25.5 11.2 26.9
56911 1.2 3.6 26.6 11.1 26.8
This goes on for 10,000 rows or more per spreadsheet. The Identifier (first
number) is just a sample number and does not get averaged. Just the Data 1
through Data 14 (some spreadsheets have Data 1 through Data 9, etc. - not
consistent). Some samples have several data points to be averaged, other times
there is just one sample (such as 56909 above) or two (56910 and 56911 above).
Is there a way to do this that isn't too difficult?