# convert column inside a cell

1 view (last 30 days)
neamah al-naffakh on 10 Jan 2017
Commented: the cyclist on 10 Jan 2017
Hi everyone,
I have a cell (called AA ) that contains 1 row * 36 columns (as shown in the attached image)
As we could see that each column in that cell contains 3 values ( means inside each column there are 1*3)
I need to have an array that has 36 Rows * 3 columns
For example,
the first column in the Cell will be converted into 1 Row and three columns, the second column in the Cell will be converted in the same way and finally add all of them together in order to generate an array that contains 36 Rows and 3 Columns
as shown in this example
-1.48247427405830e-15 0.185513882360673 -0.185513882360676
-9.59200039657764e-16 0.211729497802758 -0.211729497802760
3.69087930153418e-16 0.224791092084074 -0.224791092084073
Really appreciate any help
Regards.

the cyclist on 10 Jan 2017
I think this does what you want
reshape(cell2mat(AA'),36,3)
##### 1 CommentShowHide None
neamah al-naffakh on 10 Jan 2017
thank you so much sir

### More Answers (1)

Walter Roberson on 10 Jan 2017
This can be done much more simply as
vertcat(A{:})
##### 1 CommentShowHide None
the cyclist on 10 Jan 2017
That's twice in one day that I've been schooled by Walter.