Calc > Matrices > Transpose

Complete the following steps to reconfigure a matrix so that rows become columns and columns become rows.

  1. In Transpose from, enter the matrix that you want to transpose.
  2. In Store result in, enter a number (for example, M1) or a name for the transposed matrix. If the name contains spaces, enclose the name in single quotation marks.
1 2 3
4 5 6
7 8 9
Original matrix
1 4 7
2 5 8
3 6 9
Transposed matrix
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy