Hello,
I am modifying a csv file using data from another sheet, having split the comma separated values into columns. The data I'm using will be averaged, and these averages will appear every 12 cells down the column. Is there a way to retrieve the data in every 12th cell and insert it into a single column in the csv file, adjacently. The columns in the csv file will then be returned to comma separated format.
Thanks in advance,
Brian
Edit: I've attached a sample file with 3 tabs. First tab is source data with 5-second readings, the other two are csv files with one-minute readings.
Bookmarks