The Excel TRANSPOSE function “flips” the orientation of a given range or array: TRANSPOSE flips a vertical range to a horizontal range, and flips a horizontal range to a vertical range.

Purpose 

Flip the orientation of a range of cells

Return value 

An array in a new orientation.

Syntax 

=TRANSPOSE (array)

Arguments 

  • array – The array or range of cells to transpose.

Uses

The TRANSPOSE function converts a vertical range of cells to a horizontal range of cells or a horizontal range of cells to a vertical range of cells. In other words, TRANSPOSE “flips” the orientation of a given range or array:

  1. When given a vertical range, TRANSPOSE converts it to a horizontal range
  2. When given a horizontal range, TRANSPOSE converts it to a vertical range

When an array is transposed, the first row becomes the first column of the new array, the second row becomes the second column of the new array, the third row becomes the third column of the new array, and so on.

TRANSPOSE can be used with both range and arrays. Transposed ranges are dynamic. If data in the source range changes, TRANSPOSE will immediately update data in the target range.

0
Would love your thoughts, please comment.x
()
x