Transpose multiple columns to one row

Hi there,

I have a file with 41 sheets and I'm trying to read data from column o from sheet1. Then I try to transpose that column into a row. And lastly I will repeat the above: reading column o again from sheet2 and transpose column o into the first row following the previous cells. I can't figure out how to add the transpose into my for loop, can anyone help with that?

Here is my code:

num_sheets = 41; 
C = []
for i = 3:num_sheets
    data = readmatrix('filename',i ,Range="O2:O57");
    C = [C data(:,1)];
end

Thanks a lot!!

Answer 1

[Matt J]

num_sheets = 41; 
C = cell(1,num_sheets);
for i = 3:num_sheets
    C{i} = readmatrix('filename',i ,Range="O2:O57").';
end

C=cell2mat(C);