Formatting data in scattered rows into rows following each other

[MorneDJ]

Hi All,

I have been searching the net and this forum to see how to do that, but I have been unable to find a way to do that. I do noise studies, and typically I have data in a number of columns in an excel spreadsheet (below example of maximum noise levels recorded during a 10-minute measurement).

2016/12/07 13:45 92.4
2016/12/07 13:55 90
2016/12/07 14:05 92.6
2016/12/07 14:15 91.6
2016/12/07 14:25 94
2016/12/07 14:35 97.7
2016/12/07 14:45 95.1
2016/12/07 14:55 96.3
2016/12/07 15:05 92.7
2016/12/07 15:15 93.8
2016/12/07 15:25 86.8
2016/12/07 15:35 88


2016/12/07 15:45 87.6

I need to calculate the equivalent value over an hour period (a logarithmic calculation ) which is easy. The problem is that the value is reported in every 6th row. If I have a few hours of data it is not a problem as I just copy and paste, but I have three projects where I have a few weeks worth of data and this is not possible for me to do this manually. Can anyone propose a way that I can do this to allow Excel to either calculate it in following rows, or so that I can do the calculation and by running a macro or a VBA programme I can get it in following rows (something like this).

2016/12/07 13:45 94.7
2016/12/07 14:45 99.3
2016/12/07 15:45 97.1

Thanks