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 commentaire

Rahul Govani
Rahul Govani le 13 Août 2013
I want the data to look like:
Timestamp,Data1 TimeStamp,Data2

Connectez-vous pour commenter.

Réponses (0)

Catégories

Question posée :

le 13 Août 2013

Community Treasure Hunt

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

Start Hunting!

Translated by