MATLAB Answers

0

Combining Cells into a single cell

Asked by Hello kity on 9 Jan 2013
Latest activity Commented on by Pooja Patel on 24 Feb 2017

How can I combine multiple cells in to a single cell

there are 6 cells, each m x n format (n is 17 in all)

I want a new cell created that just adds up below

so for example Cell1 is 50x17 Cell2 is 30x17 Cell3 is 20x17

new cell should then be : AllCell is 100x17

I thought of:

Allcell=cell(Cell1+Cell2+Cell3,17);

but what then

  4 Comments

Show 1 older comment

It slightly confusing: Do you want AllCell to be a scalar cell, which contains a 100x17 matrix?

I found a way but i think it should be easier.

raw is from xlsread, a cell.

A=length(raw1);
B=length(raw2);
C=length(raw3);
D=length(raw4);
E=length(raw5);
F=length(raw6);
lengthcell=A+B+C+D+E+F;
All=cell(lengthcell+5,17);
All(1:A, 1:17)=raw1;
All(A+2:A+B+1, 1:17)=raw2;
All(A+B+3:A+B+2+C, 1:17)=raw3;
All(A+B+C+4:A+B+C+D+3, 1:17)=raw4;
All(A+B+C+D+5:A+B+C+D+E+4, 1:17)=raw5;
All(A+B+C+D+E+6:A+B+C+D+E+F+5, 1:17)=raw6;

between every set of data there is a cell row free.

AllCell = [Cell1; Cell2; Cell3];

Log in to comment.

Products

No products are associated with this question.

2 Answers

Answer by Thorsten
on 9 Jan 2013
Edited by Thorsten
on 9 Jan 2013
 Accepted Answer

use the standard concatenation operator [ ]

AllCell = [Cell1; Cell2; Cell3; Cell4; Cell5; Cell6];

  2 Comments

hmm, i tried this but with , instead of ; inbetween the Cells.

Thank you

Thanks a lot dear Thorsten. It reclaim me

Log in to comment.


Answer by Jan Simon
on 9 Jan 2013

If your cells are not called "Cell1", "Cell2", ... but you use an index as index (as suggested repeatedly and consequently in this forum), the concatenation is even easier:

C{1} = rand(50, 17);
C{2} = rand(10, 17);
C{3} = rand(40, 17);
C{4} = rand(30, 17);
C{5} = rand(20, 17);
AllC = {cat(1, C{:})};

  5 Comments

Yeah, I know. But she's a beginner and beginners often think they want something when some other way is better, simpler, and easier. For example to get the 5th row, 16th column you could simply and naturally do theBigArray(5, 16). OR do something more complicated like AllCell(1){5, 16} or maybe it's just AllCell{5, 16} or something like that - I always have to play around with braces and parentheses til I get it right, that's why I avoid cell arrays if at all possible.

thanks simon, very usefull

thank you so much mr.simon. this is working very well.

Log in to comment.


Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

MATLAB Academy

New to MATLAB?

Learn MATLAB today!