Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

How to Transpose the Report?

  1. Last updated
  2. Save as PDF
This page provides guidance on manually transposing report data for improved readability, including sample usage and syntax for the TRANSPOSE function.

We recommend manually transposing the report after it is generated for a better experience. Please follow the below instruction on Transposing.

Transposes the rows and columns of an array or range of cells.

Sample Usage:

TRANSPOSE({1,2;3,4;5,6})

TRANSPOSE(A2:F9)

Syntax:

TRANSPOSE(array_or_range)

array_or_range - The array or range whose rows and columns will be swapped.


Note: Transposition works by converting the value in the "nth" row and "mth" column into the value in the "mth" row and "nth" column. 

The value from the fourth row and second column will be assigned to the second row and fourth column. Transposing a range of m rows by n columns yields n rows by m columns.

Examples:

undefined