For each unique SiteID listed in column B of the attached Excel sheet, I would like to generate 7-day rolling averages of the data found in columns E, F and G.
I have manually generated the 7-day rolling averages for the first two sites (04CEF-1 and 04COK-1) in columns H, I, and J. The next set of 7-day averages should begin in row 189 (as indicated in the attached spreadsheet).
I am hoping for a solution that will automate the process of generating the 7-day rolling averages by SiteID.
Most of the SiteIDs have 92 days of data, however, this is not always the case so the solution should be able to accommodate varying data counts for each SiteID.
Many thanks in advance for any solutions!