Spreadsheet: 112801d1308797575-excel-2007-average-every-nth-group-of-rows-into-new-column-ptgroupbyminutes
Sheet: Sheet1

Time | Data | Number
 |  |  |  | Sum of Number | Column Labels
 |  |  |  | Row Labels | AA | BB | CC | DD | EE | Grand Total
 |  |  |  | 7 PM |  |  |  |  |  |  |  | <<This pivot table is grouped by minutes or every 60 seconds.
 |  |  |  | :14 |  | 41 | 36 | 50 |  | 127
 |  |  |  | :15 | 42 | 11 |  | 77 | 23 | 153
 |  |  |  | :16 | 47 | 46 |  |  | 36 | 129
 |  |  |  | :17 | 56 |  |  |  | 46 | 102
 |  |  |  | :18 | 40 |  | 29 | 32 | 36 | 137
 |  |  |  | :19 | 14 |  | 46 | 40 | 70 | 170
 |  |  |  | :20 |  | 22 |  | 35 |  | 57
 |  |  |  | :21 | 24 |  |  |  | 33 | 57
 |  |  |  | :22 |  | 79 | 14 | 91 |  | 184
 |  |  |  | :23 |  | 28 | 2 | 17 | 24 | 71
 |  |  |  | :24 |  |  | 40 | 20 |  | 60
 |  |  |  | :25 | 19 | 44 | 75 |  |  | 138
 |  |  |  | :26 | 37 | 52 |  |  | 19 | 108
 |  |  |  | :27 | 12 | 44 | 42 | 46 |  | 144
 |  |  |  | :28 |  |  |  | 16 | 36 | 52
 |  |  |  | :29 | 89 |  | 1 | 87 | 33 | 210
 |  |  |  | :30 |  | 39 | 70 | 4 |  | 113
 |  |  |  | :31 | 31 |  |  | 63 |  | 94
 |  |  |  | :32 | 129 | 12 |  | 42 |  | 183
 |  |  |  | :33 | 8 |  |  |  |  | 8
 |  |  |  | :34 |  |  |  | 40 | 15 | 55
 |  |  |  | :35 | 43 | 60 |  |  | 37 | 140
 |  |  |  | :36 | 19 | 4 | 28 | 45 | 2 | 98
 |  |  |  | :37 | 14 | 41 | 16 | 24 | 26 | 121
 |  |  |  | :38 | 53 |  | 36 | 32 |  | 121
 |  |  |  | :39 | 26 | 31 | 49 | 84 |  | 190
 |  |  |  | :40 | 10 | 49 | 106 | 38 |  | 203
 |  |  |  | :41 | 7 |  |  |  | 70 | 77
 |  |  |  | :42 | 62 |  | 3 | 51 | 80 | 196
 |  |  |  | :43 | 5 | 18 | 21 |  |  | 44
 |  |  |  | :44 | 21 | 28 |  |  |  | 49
 |  |  |  | :45 |  | 40 | 23 |  |  | 63
 |  |  |  | :46 | 6 | 23 | 47 | 78 | 54 | 208
 |  |  |  | :47 | 5 | 45 |  | 43 |  | 93
 |  |  |  | :48 | 49 | 46 |  | 26 | 39 | 160
 |  |  |  | :49 | 37 | 20 | 32 | 7 | 74 | 170
 |  |  |  | :50 | 54 |  | 44 |  | 6 | 104
 |  |  |  | :51 |  |  |  | 49 |  | 49
 |  |  |  | :52 |  |  | 23 | 40 |  | 63
 |  |  |  | :53 |  |  | 88 | 31 | 15 | 134
 |  |  |  | :54 | 75 |  | 9 |  | 17 | 101
 |  |  |  | :55 | 113 |  |  | 43 |  | 156
 |  |  |  | :56 |  | 32 | 14 |  | 45 | 91
 |  |  |  | :57 | 45 |  |  |  |  | 45
 |  |  |  | :58 |  |  | 1 | 10 | 37 | 48
 |  |  |  | :59 | 16 |  | 27 | 55 | 24 | 122
 |  |  |  | 8 PM
 |  |  |  | :00 |  | 15 | 38 | 37 |  | 90
 |  |  |  | :01 |  |  | 27 | 50 | 45 | 122
 |  |  |  | :02 | 8 | 27 | 48 | 36 |  | 119
 |  |  |  | :03 | 38 |  | 3 | 15 |  | 56
 |  |  |  | :04 | 58 |  |  |  | 13 | 71
 |  |  |  | :05 | 41 |  |  | 16 |  | 57
 |  |  |  | :06 |  |  | 27 | 44 | 53 | 124
 |  |  |  | :07 | 42 | 41 | 40 | 3 | 50 | 176
 |  |  |  | :09 | 50 | 24 | 35 |  | 14 | 123
 |  |  |  | :10 | 30 | 35 |  | 38 |  | 103
 |  |  |  | :11 |  | 63 | 31 | 9 |  | 103
 |  |  |  | :12 | 47 | 22 | 59 | 57 | 79 | 264
 |  |  |  | :13 | 57 | 20 | 59 | 69 |  | 205
 |  |  |  | :14 | 4 | 47 |  | 42 |  | 93
 |  |  |  | :15 |  |  |  | 38 | 34 | 72
 |  |  |  | :16 | 21 |  | 74 |  |  | 95
 |  |  |  | :17 |  |  | 35 | 52 |  | 87
 |  |  |  | :18 | 72 |  | 30 | 4 | 36 | 142
 |  |  |  | :19 | 29 |  |  | 48 | 29 | 106
 |  |  |  | :20 | 77 |  | 52 | 11 |  | 140
 |  |  |  | :21 | 65 | 64 | 49 | 16 |  | 194
 |  |  |  | :22 | 27 | 76 |  |  | 50 | 153
 |  |  |  | :23 | 39 |  |  | 45 | 33 | 117
 |  |  |  | :24 |  | 41 | 43 | 2 |  | 86
 |  |  |  | :25 |  | 7 | 64 | 52 | 34 | 157
 |  |  |  | :26 | 1 | 56 | 58 |  |  | 115
 |  |  |  | :27 | 19 | 39 | 3 |  |  | 61
 |  |  |  | :28 | 12 |  |  |  | 70 | 82
 |  |  |  | :29 |  | 11 | 6 |  | 7 | 24
 |  |  |  | :30 | 34 |  | 3 | 25 | 1 | 63
 |  |  |  | :31 | 44 | 9 | 42 |  | 20 | 115
 |  |  |  | :32 | 47 |  |  | 2 | 65 | 114
 |  |  |  | :33 |  |  |  | 41 | 31 | 72
 |  |  |  | :34 | 31 |  | 24 |  | 71 | 126
 |  |  |  | :36 |  |  | 31 | 24 | 47 | 102
 |  |  |  | :37 |  | 39 |  | 27 | 8 | 74
 |  |  |  | :38 | 77 |  | 49 |  |  | 126
 |  |  |  | :39 | 78 | 5 | 24 | 12 |  | 119
 |  |  |  | :40 |  | 33 |  |  |  | 33
 |  |  |  | :41 |  |  |  | 76 | 10 | 86
 |  |  |  | :42 |  |  |  | 34 |  | 34
 |  |  |  | :43 |  | 35 |  |  | 80 | 115
 |  |  |  | :44 |  |  |  | 42 | 60 | 102
 |  |  |  | :45 | 10 | 48 |  | 56 |  | 114
 |  |  |  | :46 |  | 41 |  | 25 |  | 66
 |  |  |  | :47 | 32 |  | 34 | 54 |  | 120
 |  |  |  | :48 | 7 | 24 | 68 |  | 44 | 143
 |  |  |  | :49 |  |  | 40 |  | 69 | 109
 |  |  |  | :50 | 16 | 27 | 23 | 47 |  | 113
 |  |  |  | :51 | 94 |  |  |  |  | 94
 |  |  |  | :52 | 90 | 18 |  | 26 | 3 | 137
 |  |  |  | :53 |  | 20 |  | 34 | 39 | 93
 |  |  |  | :54 | 4 |  | 18 | 51 | 2 | 75
 |  |  |  | :55 |  |  | 11 | 64 | 49 | 124
 |  |  |  | :56 | 57 | 43 |  |  | 26 | 126
 |  |  |  | :57 | 44 |  | 28 |  | 34 | 106
 |  |  |  | :58 |  |  | 34 |  |  | 34
 |  |  |  | :59 |  |  | 19 |  | 50 | 69
 |  |  |  | 9 PM
 |  |  |  | :00 |  |  | 63 |  | 17 | 80
 |  |  |  | :01 |  | 24 | 45 | 36 |  | 105
 |  |  |  | :02 | 13 |  |  |  | 21 | 34
 |  |  |  | :03 |  | 22 |  | 34 |  | 56
 |  |  |  | :04 |  |  | 69 | 22 | 31 | 122
 |  |  |  | :05 | 32 |  |  | 28 | 10 | 70
 |  |  |  | :06 | 13 |  |  |  |  | 13
 |  |  |  | :07 | 38 |  |  | 47 | 93 | 178
 |  |  |  | :08 |  | 29 |  |  | 44 | 73
 |  |  |  | :09 | 5 |  | 39 | 23 | 43 | 110
 |  |  |  | :10 | 25 | 15 |  | 39 | 25 | 104
 |  |  |  | :11 | 45 | 3 | 31 | 38 | 5 | 122
 |  |  |  | :12 | 14 |  | 75 |  | 9 | 98
 |  |  |  | :13 |  | 12 | 39 | 46 |  | 97
 |  |  |  | :14 | 45 | 37 | 36 | 44 | 30 | 192
 |  |  |  | :15 |  |  |  |  | 45 | 45
 |  |  |  | :17 |  | 1 |  | 50 |  | 51
 |  |  |  | :18 |  | 10 |  | 17 | 33 | 60
 |  |  |  | :19 |  |  | 37 |  | 43 | 80
 |  |  |  | :20 |  | 35 | 32 | 26 |  | 93
 |  |  |  | :21 | 33 |  |  |  |  | 33
 |  |  |  | :22 | 32 | 31 |  |  |  | 63
 |  |  |  | :23 |  | 85 | 13 |  |  | 98
 |  |  |  | :24 | 49 | 41 | 46 |  |  | 136
 |  |  |  | :25 | 83 | 43 | 26 | 10 |  | 162
 |  |  |  | :26 | 15 | 8 | 50 |  |  | 73
 |  |  |  | :27 |  | 8 | 28 | 3 | 29 | 68
 |  |  |  | :28 |  | 43 |  | 28 | 42 | 113
 |  |  |  | :29 | 31 | 6 |  |  |  | 37
 |  |  |  | :30 | 15 |  | 31 |  |  | 46
 |  |  |  | :31 | 6 | 48 |  | 2 | 29 | 85
 |  |  |  | :32 | 19 |  |  |  |  | 19
 |  |  |  | :33 | 48 | 33 |  |  | 81 | 162
 |  |  |  | :34 | 39 |  | 19 | 34 | 45 | 137
 |  |  |  | :35 |  | 37 |  | 28 |  | 65
 |  |  |  | :36 | 40 | 9 | 31 | 16 |  | 96
 |  |  |  | :37 |  |  | 41 |  |  | 41
 |  |  |  | :38 | 29 |  | 40 | 5 | 5 | 79
 |  |  |  | :39 |  |  | 71 | 28 | 23 | 122
 |  |  |  | :40 |  | 71 |  | 71 |  | 142
 |  |  |  | :41 | 35 |  |  | 35 |  | 70
 |  |  |  | :42 |  | 7 |  |  |  | 7
 |  |  |  | :43 |  | 49 |  | 58 | 82 | 189
 |  |  |  | :44 |  | 37 | 38 | 42 | 9 | 126
 |  |  |  | :45 |  | 72 | 49 | 50 | 14 | 185
 |  |  |  | :46 | 42 | 33 | 48 | 5 | 49 | 177
 |  |  |  | :47 |  |  | 83 | 36 | 43 | 162
 |  |  |  | :48 | 94 | 4 | 20 | 40 | 13 | 171
 |  |  |  | :49 |  | 27 |  |  | 65 | 92
 |  |  |  | :50 |  | 70 |  |  | 80 | 150
 |  |  |  | :51 | 16 | 59 | 43 |  | 18 | 136
 |  |  |  | :52 |  |  | 24 | 18 | 42 | 84
 |  |  |  | :53 |  | 42 | 21 |  |  | 63
 |  |  |  | :54 |  | 89 | 131 | 31 |  | 251
 |  |  |  | :55 | 12 | 53 | 23 | 24 | 15 | 127
 |  |  |  | :56 | 78 | 19 |  | 34 | 25 | 156
 |  |  |  | :57 | 66 |  | 64 | 27 | 20 | 177
 |  |  |  | :58 |  |  |  | 50 | 40 | 90
 |  |  |  | :59 | 4 | 51 |  |  | 39 | 94
 |  |  |  | 10 PM
 |  |  |  | :00 | 26 |  |  | 2 | 29 | 57
 |  |  |  | :01 | 42 | 8 | 30 | 90 | 40 | 210
 |  |  |  | :02 | 62 |  |  | 83 |  | 145
 |  |  |  | :03 |  | 50 |  | 10 |  | 60
 |  |  |  | :04 |  |  | 31 |  | 43 | 74
 |  |  |  | :05 | 31 | 8 | 31 | 36 | 41 | 147
 |  |  |  | :06 | 86 |  | 11 | 124 | 60 | 281
 |  |  |  | :07 | 25 | 6 | 26 |  |  | 57
 |  |  |  | :08 | 43 |  |  | 41 | 89 | 173
 |  |  |  | :09 | 64 |  | 4 |  |  | 68
 |  |  |  | :10 |  | 30 |  | 15 | 10 | 55
 |  |  |  | :11 | 41 | 48 |  |  | 46 | 135
 |  |  |  | :12 | 38 |  | 19 |  | 15 | 72
 |  |  |  | :13 |  |  |  |  | 49 | 49
 |  |  |  | :14 | 10 |  | 34 |  | 61 | 105
 |  |  |  | :15 |  | 25 | 11 |  |  | 36
 |  |  |  | :16 |  | 29 | 12 |  | 43 | 84
 |  |  |  | :17 | 44 |  | 90 | 28 |  | 162
 |  |  |  | :18 | 31 | 83 | 45 | 7 |  | 166
 |  |  |  | :19 | 45 | 58 | 47 | 91 |  | 241
 |  |  |  | :20 | 25 |  | 29 | 4 |  | 58
 |  |  |  | :21 | 41 | 8 | 16 |  | 13 | 78
 |  |  |  | :22 | 10 |  | 40 | 39 | 41 | 130
 |  |  |  | :23 | 29 | 48 | 65 | 29 | 47 | 218
 |  |  |  | :24 |  |  |  |  | 92 | 92
 |  |  |  | :25 | 10 | 39 |  | 47 | 50 | 146
 |  |  |  | :26 |  |  |  |  | 43 | 43
 |  |  |  | :27 |  | 2 | 127 | 16 | 20 | 165
 |  |  |  | :28 | 3 |  |  | 54 |  | 57
 |  |  |  | :29 |  | 9 | 51 | 23 |  | 83
 |  |  |  | :30 |  | 29 |  | 58 | 4 | 91
 |  |  |  | :31 | 33 |  | 46 | 45 |  | 124
 |  |  |  | :32 | 33 |  |  | 9 | 37 | 79
 |  |  |  | :33 |  | 26 | 85 |  | 7 | 118
 |  |  |  | :34 | 10 | 39 | 28 |  |  | 77
 |  |  |  | :35 | 8 | 4 |  |  | 4 | 16
 |  |  |  | :36 |  | 47 |  | 14 |  | 61
 |  |  |  | :37 | 1 |  | 10 |  | 20 | 31
 |  |  |  | :38 | 44 |  | 15 |  | 5 | 64
 |  |  |  | :39 | 12 |  |  |  |  | 12
 |  |  |  | :40 |  | 53 |  | 53 |  | 106
 |  |  |  | :41 | 24 | 32 |  |  | 10 | 66
 |  |  |  | :42 | 76 | 48 | 34 | 35 | 12 | 205
 |  |  |  | :43 |  |  | 22 | 89 | 28 | 139
 |  |  |  | :44 | 45 |  | 8 | 33 |  | 86
 |  |  |  | :45 |  | 29 |  |  |  | 29
 |  |  |  | :46 |  |  | 46 |  | 19 | 65
 |  |  |  | :47 |  | 49 | 41 | 29 |  | 119
 |  |  |  | :48 |  |  |  | 46 |  | 46
 |  |  |  | :49 | 77 |  |  |  | 28 | 105
 |  |  |  | :50 | 49 | 24 | 2 |  |  | 75
 |  |  |  | :51 |  | 21 |  |  |  | 21
 |  |  |  | :52 | 74 | 41 | 35 | 8 | 38 | 196
 |  |  |  | :53 |  |  | 60 | 41 | 38 | 139
 |  |  |  | :54 | 31 | 30 |  | 45 | 19 | 125
 |  |  |  | :55 |  |  | 12 | 4 | 83 | 99
 |  |  |  | :56 | 20 | 14 | 50 | 30 |  | 114
 |  |  |  | :57 | 44 |  | 26 | 29 |  | 99
 |  |  |  | :58 | 17 | 70 | 3 | 78 |  | 168
 |  |  |  | :59 | 25 |  | 31 | 66 | 42 | 164
 |  |  |  | 11 PM
 |  |  |  | :00 |  |  |  |  | 94 | 94
 |  |  |  | :01 |  | 36 |  | 23 | 25 | 84
 |  |  |  | :02 | 36 | 34 | 73 |  |  | 143
 |  |  |  | :03 |  | 99 | 32 |  | 42 | 173
 |  |  |  | :04 |  |  | 89 |  | 47 | 136
 |  |  |  | :05 | 1 |  | 31 |  | 50 | 82
 |  |  |  | :06 | 47 |  |  |  | 73 | 120
 |  |  |  | :07 | 15 |  | 15 | 24 | 17 | 71
 |  |  |  | :08 |  |  | 23 | 28 |  | 51
 |  |  |  | :09 |  | 12 |  | 45 |  | 57
 |  |  |  | :10 |  | 64 | 58 | 42 |  | 164
 |  |  |  | :11 |  |  |  | 33 |  | 33
 |  |  |  | :12 | 46 |  |  | 17 | 28 | 91
 |  |  |  | :13 |  | 120 |  |  |  | 120
 |  |  |  | Grand Total | 5100 | 4420 | 5151 | 5428 | 5012 | 25111