from 8760 x 1 to 1 x 8760 ??

I have wind speed data over the year in an excel's coloumn (8760 X 1) and i need to import it in matlab. The problem is that MATLAB Simulink reads the data across the matrix so i need to transpose the matrix, go from 8760 x 1 to 1 x 8760 and also MATLAB reads the first row of the matrix as the time step so i need to convert the 1 x 8760 to a 2 x 8760 where the first row is the time step eg: 1 2 3 4 5 6 7 8 9 10 …………. I need a help, please, Thank you very much

Answer 1

[sixwwwwww]

Dear you can do like this(if i understood correctly):

num = xlsread('filename.xls', 'A:A');
ind = 1:length(num);
matrix = [ind; num'];

I hope it helps. Good luck!

Answer 2

[Image Analyst]

To transpose use the apostrophe operator.

m = m';

To get the numbers sequentially use the colon operator

m2 = startingValue : stepValue : endingValue;

The step value is 1 if it's not explicitly given. So you want

out = [1:length(m); m'];