Transpose matrix and then predetermine rows
1 view (last 30 days)
Show older comments
Hi
I have a data spreadsheet in Excel that consists of 1 column and 8760 rows. This is raw hourly temperature readings over a one year period.
I want to use Matlab to convert the 8760 row x 1 column to a 365 row x 24 hour column.
I have tried to transpose the matrix but I can only get it to give me 1 row and 8760 columns.
How can I get it to change row every 24 readings.
Thanks
0 Comments
Accepted Answer
Sean de Wolski
on 7 Jul 2011
doc reshape;
Data = reshape(x, [24,365])'; %reshape and then transpose
0 Comments
More Answers (1)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!