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 件のコメント

Rahul Govani
Rahul Govani 2013 年 8 月 13 日
I want the data to look like:
Timestamp,Data1 TimeStamp,Data2

サインインしてコメントする。

回答 (0 件)

カテゴリ

ヘルプ センター および File ExchangeData Import from MATLAB についてさらに検索

質問済み:

2013 年 8 月 13 日

Community Treasure Hunt

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

Start Hunting!

Translated by