What is TRANSPOSE Function?

Some users arrange data horizontally in rows worksheets while others arrange data in the vertical form in columns. Therefore, for the ease of users, the TRANSPOSE function in Excel provides the facility of changing the orientation of the given range.  

Purpose of TRANSPOSE Function

The main purpose of the TRANSPOSE function is to rotate or switch the orientation of cells within a particular range. The horizontal orientation can be transformed into vertical and vice versa.

Syntax of TRANSPOSE Function

The syntax of the TRANSPOSE function is given below.

TRANSPOSE (array)

Arguments

There is only one argument in this function which is described below.

Array: this is the range of cells that you want to transpose in the Excel worksheet. You create the transpose by mentioning the first row of the selected array as the first column of the newly created array. Similarly, the second row of the selected array will be transposed to the second column of the newly created array, and so on.

Example

For example, you want to transpose the range of the array from B6 row to column F10. You will write the formula to transpose as the following.

= TRANSPOSE (B6:F10)