Macro to Copy Every nth Cell to Another Column or Sheet

dlabert

New Member
Joined
Jul 19, 2012
Messages
1
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!
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,720
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top