How to Transpose a Matrix in Excel Correctly

Опубликовано: 05 Октябрь 2024
на канале: FigureAssist
1,189
5

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"