# how to rearrange cell array with the grouped sequence

1 view (last 30 days)
Shannon on 10 Jan 2020
Commented: Shannon on 10 Jan 2020
I have a cell array in this format:
21 3 '1'
31 2 '1 1'
25 1 '2 2 1 1'
How can I rearrange the cell array to:
21 3 1
31 2 1
31 2 1
25 1 2
25 1 2
25 1 1
25 1 1
Thank you!

#### 1 Comment

Adam Danz on 10 Jan 2020
So within each cell array there are two numeric values and a char array?
Could you show us the actual cell values formatted correctly?
For example,
C =
3×3 cell array
{[21]} {[3]} {'1' }
{[31]} {[2]} {'1 1' }
{[25]} {[1]} {'2 2 1 1'}

Adam Danz on 10 Jan 2020
C is your input array as I've understood it; D is the output matrix.
% Produce input array
C = {21 3 '1'
31 2 '1 1'
25 1 '2 2 1 1'};
% Convert strings in column 3 to vectors
Cv = cellfun(@(s)str2double(strsplit(s)).',C(:,3),'UniformOutput',false);
% Replicate the rows of C(:,[1,2]) for each value in Cv
C2 = arrayfun(@(i)repmat([C{i,[1,2]}],numel(Cv{i}),1),1:size(C,1),'UniformOutput',false)';
% Combine C2 with Cv values
D = [cell2mat(C2), cell2mat(Cv)];
Result
D =
21 3 1
31 2 1
31 2 1
25 1 2
25 1 2
25 1 1
25 1 1

#### 1 Comment

Shannon on 10 Jan 2020
Many thanks! I am testing it. Will get back to you.

Stephen Cobeldick on 10 Jan 2020
>> C = {21,3,'1';31,2,'1 1';25,1,'2 2 1 1'}
C =
[21] [3] '1'
[31] [2] '1 1'
[25] [1] '2 2 1 1'
>> V = cellfun(@(s)sscanf(s,'%f'),C(:,3),'uni',0);
>> Z = [repelem(C(:,1:2),cellfun('length',V),1),num2cell(vertcat(V{:}))]
Z =
[21] [3] [1]
[31] [2] [1]
[31] [2] [1]
[25] [1] [2]
[25] [1] [2]
[25] [1] [1]
[25] [1] [1]

#### 1 Comment

Shannon on 10 Jan 2020
Many thanks! It works!