ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selecting a subset of data from multi columns (https://www.excelbanter.com/excel-discussion-misc-queries/186536-selecting-subset-data-multi-columns.html)

al

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

Dave

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