Converting 10 minute interval data into hourly average

Hi all!

I have tens of thousands of lines of data for every 10 minutes for every day in a year and I need to get the hourly average from every hour and every day, so it would be like day 1 hours 1-24, day 2 1-24 etc. I have the average values already (every 10 minute data for one hour has the same value). I already tried using the OFFSET function and it almost worked, but I am left with a bit less than half a month of no data. What else could I try to get everything I need?
The offset function looks the following:
=OFFSET($J$2;(ROW(J1)-1)*6;0)
J is the column with average values and I want data form every 6th line.

Hi and welcome

Could we see some sample data and a handful of manually generated expected results?

See the yellow banner at the top of the page for details on attaching a file (not a picture of your file!)

BSB

Here is the example with 3 hours worth of data (including previously calculated averages) and the expected results.

why not a simple pivottable with whatever columns from a to E as your rows and average as the vlaue