Flip a matrix from 31 x 1000 to 1000 x 31 and retain same order of elements
1 view (last 30 days)
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.