Flip a matrix from 31 x 1000 to 1000 x 31 and retain same order of elements

1 次查看(过去 30 天)
Hi!
I have created a 31 x 1000 matrix. The 31 are years from 2020 to 2050, while the 1000 are different simulation outcomes. I will export this to Excel where my years are ordered horizontally, and the outcomes of the simulation vertically. Therefore I need the outcome to be 1000 x 31. How can I flip the matrix so that I achieve this? The elements need to follow each other exactely, because they represent yearly revenues.
Thanks,
Mak

采纳的回答

Kevin Holly
Kevin Holly 2021-10-12
You can tranpose the matrix with a '
matrix = rand(3,10)
matrix = 3×10
0.1734 0.4955 0.4469 0.7261 0.6025 0.6068 0.0785 0.0159 0.2856 0.7666 0.3577 0.8180 0.6540 0.2144 0.7027 0.2941 0.3335 0.1094 0.6542 0.1000 0.3746 0.8411 0.4985 0.5843 0.1917 0.4901 0.7395 0.6821 0.2456 0.7785
matrix_transposed = matrix'
matrix_transposed = 10×3
0.1734 0.3577 0.3746 0.4955 0.8180 0.8411 0.4469 0.6540 0.4985 0.7261 0.2144 0.5843 0.6025 0.7027 0.1917 0.6068 0.2941 0.4901 0.0785 0.3335 0.7395 0.0159 0.1094 0.6821 0.2856 0.6542 0.2456 0.7666 0.1000 0.7785

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Matrices and Arrays 的更多信息

产品


版本

R2016b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by