How to transpose multiple rows into one column?

Dear all,

I have an Excel sheet with a data matrix. It's nummeric data; 18 columns wide, each 200 rows long. I would like Matlab to read the Excel file, and to transpose each of the rows below the previous one, in one single column. The end result should be 1 column with 3600 rows. It would be great if Matlab would save this column in a new txt or csv file.

Matlab info: I am using Matlab R2017b

Thanks for your help,

Jürgen

Answer 1

[KSSV]

num = xlsread(myfile) ; 
data = num(:) ; 

Read about fprintf, save, dlmwrite, to write the data into your required file.

Answer 2

[Surafel]

num = xlsread(Your file Location) ;

Transpose = num'

data = Transpose(:) ;