Hi,
I have a spreadsheet with downloaded data from 19 components. Row 2, 21, 40, etc. contains data for component 1. Rows 3, 22, 41 for component 2, and so on. The data is collected for each component every 10 seconds. Column A is date and B is time, so these columns would be the same for 19 rows and then the time would increase by 10 seconds for the next 19 rows, etc. Column E is the component's name and column G contains data that I need to average into 1 minute and 5 minute intervals. I have over 92,000 rows of data. I would like to create a new sheet where column A and B are date and time, and column C contains the data for component 1 (rows G2, G21, G40, etc.), column D for 1 minute averages, column E for 5 minute average, then column F for component 2 (rows 3, 22, 41, etc.), G for 1 min. average, H for 5 minute avg., column I for component 3 etc. for all 19 components. I would greatly appreciate any help you can offer. Thanks!
I have a spreadsheet with downloaded data from 19 components. Row 2, 21, 40, etc. contains data for component 1. Rows 3, 22, 41 for component 2, and so on. The data is collected for each component every 10 seconds. Column A is date and B is time, so these columns would be the same for 19 rows and then the time would increase by 10 seconds for the next 19 rows, etc. Column E is the component's name and column G contains data that I need to average into 1 minute and 5 minute intervals. I have over 92,000 rows of data. I would like to create a new sheet where column A and B are date and time, and column C contains the data for component 1 (rows G2, G21, G40, etc.), column D for 1 minute averages, column E for 5 minute average, then column F for component 2 (rows 3, 22, 41, etc.), G for 1 min. average, H for 5 minute avg., column I for component 3 etc. for all 19 components. I would greatly appreciate any help you can offer. Thanks!