Averaging rows by irregular values in Column X

[MaverickBlack]

I am working to align data files from various sources for a research project, and I am trying to convert all of the data files so that 1 row = 1 second so that they can be easily aligned.
However, my different programs record data at irregular rates. For example the program that captured the data in my HK_Participant2 file samples very irregularly between 5 & 10 hz, while my Participant2_Trial3.simdata files record at a varying 8-10 hz.

I am trying to figure out how I can create a macro that will take the average of the rows within each second (in column B in both of my Worksheets) and output it to a new worksheet, but I am new to this and in over my head here.


Thanks