Export certain cells of a structure into a table (.csv file)

I'm using Matlab2015a -- I cannot attach the data structure because the file is too large

My data is in a 1x80 struct with 68 fields.Each cell contains data as an nx1 double (data in .mat format here: https://merced-my.sharepoint.com/:u:/g/personal/jkaur28_ucmerced_edu/ET489-KS_lJEoI5dUabFTX4B8wUcIf6_cT2kuS0QXIuteA).

For every row in the structure, I want to extract the values from in each cell in one column a table. So for the row called Field 1, I want a table with columns Right_HandX, RightHandY, RightHandXVec...etc and rows 1:number of values in the cell.

I want to end up with 80 tables for each of these structures, which I can write to separate csv files.

I have used T = struct2table(trials) and it makes a table that looks identical to the structure. I've also tried cell2table(trials) which did the same thing. Once I have the data organized in the correct format I can easily use writetable(T, filename) to save as a csv. I just need help getting the data out of the structure and into a well organized table.

[Image Analyst]

I'm not sure if your data is in a table, a cell array, or a structure, so please attach it with the paperclip icon in a .mat file.

save('answers.mat', 'trials');

after you read the posting guidelines again:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[Jaskanwaljeet Kaur]

thanks for the tip, I've made some edits

[Arif Hoq]

I think you can use a drive to upload your file(as it's large) and please provide the drive link.

[Jaskanwaljeet Kaur]

Thanks for the suggestion, link is now available.

Answer 1

[Sulaymon Eshkabilov]

One quick solution with your large data to separate them and write to an external file is the following in the example of two field variables, viz. Right_HandX and Right_HandY:

load('trials.mat');
FN='Data.xlsx';
for ii=1:80
X = trials(ii).Right_HandX;
Y = trials(ii).Right_HandY;
writematrix([X,Y],FN,'Sheet',ii)
end

This is how you can take out every column of your data and write them to an external file, e.g.: MS Excel or .txt or .dat or .csv