Export cell array into Excel

Hello All,

I have been asked to quickly put together a data extraction tool for some data being collected for a research project. The data has been exported into a 36x1 cell (data_1) which comprises of 36 14x1 double vectors.

I have been asked that this data is exported onto one excel sheet. From what I have read I need to take the cell array data_1 and turn it into one 14x36 cell array.

Below is that code that I have been working with along with a screenshoot of the current output. As you can see there are 36 cells which are not correct however the rest of the data in the cell is correct.

What am I doing wrong?

Many thanks in advance

for ii = 1:length(Trials)
    
    data_1_extraction = data_1{ii,1}; % Extract first cell.
    ca{ii} = cell(14,length(Trials));
    for row = 1 : size(data_1_extraction, 1)
    ca{row,ii} = data_1_extraction(row);
end

end

Answer 1

[dpb]

C=num2cell(cell2mat(data_1.'));
xlswrite(file,C,sheet,range)