This video shows how to correctly transpose a matrix in Microsoft Excel.
To begin, select blank cells which have reversed dimensions to the matrix you want to transpose. Then, type =transpose() and highlight the original matrix.
Once you have entered the formula, press ctrl+shift+enter at the same time to perform the calculation over multiple cells.
Timestamps
0:00 Making sure dimensions are correct
0:18 Transpose function
0:39 Shortcut "Paste Special Transpose"