TRANSPOSE()

Syntax. TRANSPOSE(array)

Definition. This function transposes arrays.

Arguments

  • array (required). A reference to a cell range or an array constant

Background. Use TRANSPOSE() as an array formula for a range that includes the same number of rows or columns as the initial array. The rows and columns are exchanged: The rows in the “old” array become the columns in the “new” array. The first row becomes the first column, the second row becomes the second column, and so on.

Important

The range with the initial array cannot contain empty cells; if it does, you will get the #VALUE! error.

If you don’t use the necessary number of rows or columns in the destination range, the missing content is truncated. If you use too many rows or columns, the excess ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.