How to combine multiple columns into a single column?

219 views (last 30 days)
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
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

Sign in to comment.

Accepted Answer

Azzi Abdelmalek
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
Mischa Kim on 18 Apr 2014
Edited: Mischa Kim on 18 Apr 2014
Cloris, use reshape
datacol = reshape(data, 12*163, [])
  1 Comment
SARA Hosseini
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 .....]

Sign in to comment.


Shubham Gorule
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.

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!