Need help performing a time normalization

Hello,

I need some help performing a time normalization on some data sets. I'm doing a kinematic analysis on the rowing stroke, comparing the drive phase of two different rowing ergometers. I need to average the hip and knee angles of ten different strokes. So right now I have ten columns of hip and knee angles from the rowing stroke, the thing is each stroke is a slightly different duration so I cannot just average them together to come up with an ensemble average. I need to normalize them so they all contain the same number of rows. For example; one column has 109 rows, the next has 103, the next 99, the next 105, etc. I want to make it so the data is on a scale of 1-100% so I can average them all together. I would appreciate any help I can get. Thanks!

Logic wise, perhaps you could try working it out via weighted calculations?

I'll try that. I'm not by any means a math person and I'm waiting to hear back from my professor. I just wanted to see if I could get a jump on things before his response. Thanks for taking the time to respond!

Try uploading the workbook.. Maybe this can help in the meantime