Convert from Rows to Column in Matlab

8 views (last 30 days)
dau
dau on 25 Nov 2013
Answered: ilker sahin on 8 May 2021
I wanted to convert a table data as: 24 hours (24 column), and 30 day (31 rows) become 1 column which with continue hours from 1-24 for the first day and for the second day so on.`
day/hours: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
1 A B C ........................................................
2 A'B'C'.....
...
31
Become
________________
day1/1hour A
day1/2hour B
day1/3hour C
..........
day2/1hour A'
day2/2hour B'
....
day31/1hour A'''
day31/2hour B'''
day31/24hour Z''''
  2 Comments
Roger Stafford
Roger Stafford on 25 Nov 2013
Hey, no fair asking the same question twice, Dau. It wastes our time when we inadvertently duplicate answers, as I just did here.
Andrei Bobrov
Andrei Bobrov on 25 Nov 2013
I deleted duplicate of question

Sign in to comment.

Answers (2)

Roger Stafford
Roger Stafford on 25 Nov 2013
If these values A, B, C, etc. as shown are in a 31 x 24 matrix called Mat1, then do:
Mat2 = reshape(Mat1',[],1);

ilker sahin
ilker sahin on 8 May 2021
Change the places between the first row and third column elements of matrix A. How can I do this?

Categories

Find more on Dates and Time 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!