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

Combining Cells into a single cell

Asked by Hello kity on 9 Jan 2013

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:


but what then


Hassan F on 9 Jan 2013

You should find your way from there on, and combine content of cell arrays.

Jan Simon on 9 Jan 2013

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

Hello kity on 9 Jan 2013

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

raw is from xlsread, a cell.

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.

Hello kity


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];

1 Comment

Hello kity on 9 Jan 2013

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

Thank you

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{:})};


Image Analyst on 9 Jan 2013

Why even mess with cells, if it's just a simple numerical matrix at that point? Just simplify it

theBigArray = cat(1, C{:}); % A matrix, not a cell - simpler, yay!
Jan Simon on 9 Jan 2013

But the OP asked for the output to be a cell explicitly: "Allcell=cell(...".

Image Analyst on 9 Jan 2013

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.

Jan Simon

Contact us