The argument is a range with the original array data. Select function: «FORMULAS»-«Lookup and Reference»-«TRANSPOSE». Select the range B7:E11 with active cell B7 in the upper left corner of the empty range. Open the 'Paste Special' menu (CTRL+ALT+V). For 5 columns there are should be five lines in an empty area, etc. There are 4 lines in the original table and the range for the transposition should have 4 columns.
Transposing the matrix is an act of changing the rows and columns in places.įirst, note the empty range where we transpose the matrix. You can perform such operations with matrices in Excel as transposition, addition, multiplication by number/array finding the inverse matrix and its determinant.
