The TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa.

  • This function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows.
  • Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet.

Syntax

=TRANSPOSE(array)

Arguments

Argument Description
array An array or range of cells on a worksheet that you want to transpose

  The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on

Examples

  A B C D E
1 Data        
2 1 2 3    
3          
4 Formula Result Notes
5 =TRANSPOSE($A$2:$C$2) 1 Value from A2 transposed into a different cell
6   2 Value from B2 transposed into a different cell, and below the value from A2 instead of to its right
7   3 Value from C2 transposed into a different cell, and below the value from B2 instead of to its right