Averaging rows by irregular values in Column X

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

Hi FDibbins and thanks for the help!

I added in the helper column, but using the Round function on time values was throwing things off (with conversion of base 10 numbers to time being somewhat convoluted). I changed it to an MROUND(B2,0.00001157407) to make it round to the whole second and it works great!

Also, is there an easy way to go about condensing the rows and outputing to a new worksheet? Adding additional columns is less of an issue with my HK files but .simdata csv files have a large number of columns that I will need to get an average for.

Thanks again!

Yes, I would pretty much like to get a summary sheet out at the end of it, with just the average values (and the corresponding timestamp). Right now I am working on a hacked together macro that kind of does this by simply filtering out the blank spots, but a summary sheet with just the average values would be ideal.

Yes that is. Unfortunately, I already got something else in place for it that is less elegant but does the job. I will definitely use your attachment as a reference for the future