Load Data from Excel sheet with set interval of data

2 views (last 30 days)
Hello all,
I have a question that may prove to be simpler than I may think. I want to load data from an excel sheet into matlab to process. I have over 30,000 data points with data collected at particular date and time.
I have 30 cells, and each cell begins at the same time and ends at the same time. Now there is only a range of data I required that repeats every cell and the rest is not needed. How do I isolate just that repeating range instead of manually complete this daunting task.
There seems to be no way to do it in excel so I thought I'd use the more useful software.
Here is also a sample of my data I want analyse to make visualising this process better.
  1 Comment
Image Analyst
Image Analyst on 19 Oct 2014
Please attach your workbook so people can try some things. Also, it's not clear what rows you want to keep and what rows you want to discard. Do you want only row 3 and whatever row "Cell 1" ends at? Or do you just want the first instance of the times, like rows 3, 5, 7, 9, etc. (all the odd rows)?

Sign in to comment.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!