![]() |
Selecting a subset of data from multi columns
Hello,
I have a data set containing times (sampled every 3 seconds) and body temperatures corresponding to the sample time. What I would like to do is somehow select every 6, 9 or 12 second time intervals and it's corresponding body temperature and move them to two new columns. I would do this manually but I have +21000 rows of data and 12 such data sheets. Is there a quicker way to do this? Any help would be appreciated. Thanks, Al |
Selecting a subset of data from multi columns
Hi,
When you say a 'data set' do you mean that the time and the temperature data is combined into one cell? If so, please give a sample of 4 or 5 cells of data. Regards - Dave. |
All times are GMT +1. The time now is 02:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com