How to combine multiple columns into a single column?
235 views (last 30 days)
Show older comments
I have a dataset of 12 rows and 163 columns, but how can I make convert it into a single column? e.g., [1 2 3 4; 5 6 7 8; 9 1 2 3; 4 5 6 7; 8 9 1 2; 3 4 5 6]
This is a 6x4 matrix, how can convert it to a single column like 1 5 9 4 8 3 2 6 1 5 9 4 3 7 2 6 1 5 4 8 3 7 2 6
But note that I have 163 columns in reality, so is there any general method to convert 163 columns to a single column? Thanks.
1 Comment
malladi siva kumari
on 21 Oct 2019
In simple way....
variable (a) = [ [1 2 3 4; 5 6 7 8; 9 1 2 3; 4 5 6 7; 8 9 1 2; 3 4 5 6]]
a =
1 2 3 4
5 6 7 8
9 1 2 3
4 5 6 7
8 9 1 2
3 4 5 6
alinear = a(:)
alinear =
1
5
9
4
8
3
2
6
1
5
9
4
3
7
2
6
1
5
4
8
3
7
2
6
Accepted Answer
Azzi Abdelmalek
on 18 Apr 2014
Edited: Azzi Abdelmalek
on 18 Apr 2014
A=[ 1 2 3 4
5 6 7 8
9 1 2 3]
out=A(:)
or
out=reshape(A,[],1)
More Answers (2)
Mischa Kim
on 18 Apr 2014
Edited: Mischa Kim
on 18 Apr 2014
datacol = reshape(data, 12*163, [])
1 Comment
SARA Hosseini
on 20 Sep 2018
How to do it for 3*1000 matrix an I want the 3 rows be in just one row for example if it is A=[1 2 3; 4 5 6; 7 8 9 ... ] I want it to be B=[1 2 3 4 5 6 7 8 9 10 .....]
Shubham Gorule
on 3 Sep 2020
let matrix be A then perform following steps
X=A(:)
Y=X'
you wil get desired result assigned to variable Y.
0 Comments
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!