Formatting large excel documents in matlab

I need to format an excel file. Currently the formatting in the excel file is: Timestamp, Data1, Data2. In matlab i need to loop the timestamp in rows, and transform the Data 1 and Data 2 from columns to rows, while matching the time stamp.
Here is the excel file: https://www.dropbox.com/s/xy75z2xfma22hfz/Dataformat2.xlsx
I had a very large excel file, so to shorten it up, i cut down the column to 3 per data set( they are highlighted in green and blue)

1 Comment

I want the data to look like:
Timestamp,Data1 TimeStamp,Data2

Sign in to comment.

Answers (0)

Categories

Asked:

on 13 Aug 2013

Community Treasure Hunt

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

Start Hunting!