Problem with array and save file?

%% create

a = cell(10,5,3);

for participant = 1:10

for video = 1:5

a{participant,video,1} = participant ;

a{participant,video,2} = video ;

a{participant,video,3} = [

"Searching for Bobby Fischer",...

"D.O.A.",...

"The Hangover",...

"The Ring",...

"300",...

];

end

end

b = cell2table(num2cell(reshape( a, [10*5, 3])),...

'VariableNames', {'participant'; 'video'; 'video_name'});

writetable(b, 'load.xlsx', 'Sheet', 1);

I have some problem with my code above. I want to write a table like each video contain with each video_name like this

but my code for a table like this

How can i do to solve this problem? Can someone edit with my code? thank you

Answer 1

[MarKf]

Do you need a 3D cell and then rehsape it or can you create it like the 2D table you want already?

videosn = ["Searching for Bobby Fischer",...
            "D.O.A.",...
            "The Hangover",...
            "The Ring",...
            "300"];   
Nparticipants = 10; Nvideos = numel(videosn); 

a = cell(Nparticipants*Nvideos,3);
for video = 1:Nvideos
    for participant = 1:Nparticipants
        idx = Nparticipants*(video-1)+participant;
        a{idx,1} = participant;
        a{idx,2} = video;
        a{idx,3} = videosn(video);  
    end
end

 b = cell2table(a,'VariableNames', {'participant'; 'video'; 'video_name'})    

b = 50×3 table
    participant    video             video_name          
    ___________    _____    _____________________________

         1           1      "Searching for Bobby Fischer"
         2           1      "Searching for Bobby Fischer"
         3           1      "Searching for Bobby Fischer"
         4           1      "Searching for Bobby Fischer"
         5           1      "Searching for Bobby Fischer"
         6           1      "Searching for Bobby Fischer"
         7           1      "Searching for Bobby Fischer"
         8           1      "Searching for Bobby Fischer"
         9           1      "Searching for Bobby Fischer"
        10           1      "Searching for Bobby Fischer"
         1           2      "D.O.A."                     
         2           2      "D.O.A."                     
         3           2      "D.O.A."                     
         4           2      "D.O.A."                     
         5           2      "D.O.A."                     
         6           2      "D.O.A."                     

% writetable(b, 'load.xlsx', 'Sheet', 1);

[Anh]

Thank for your help