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 Exchange에서 Data 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