TRANSPOSE function

The Excel TRANSPOSE function is a handy tool that helps you reorganize data in a spreadsheet. It allows you to switch the rows and columns, effectively transforming a horizontal set of data into a vertical one or vice versa. This function is especially useful when you need to convert data layouts for various purposes, such as data analysis or creating charts.




The TRANSPOSE function has only one argument:

arrayThe range of cells containing the data you want to transpose.

How to Use

Using the TRANSPOSE function is straightforward. Follow these steps:

  1. Select the cell where you want to place the transposed data.
  2. Enter the TRANSPOSE function with the range of cells you want to transpose as the ‘array’ argument. For example:

This will transpose the data from cells A1 to D4 into the selected cell.

Here are some examples to illustrate how to use the TRANSPOSE function:

Transpose Data from Rows to Columns:

This formula will take the data in cells A1 to E1 and transform it from a row into a column.

Transpose Data from Columns to Rows:

Here, the formula will take the data in cells A1 to A5 and convert it from a column into a row.

Remember that the TRANSPOSE function will dynamically adjust the size of the output range based on the source data, so you don’t need to worry about specifying the size in advance.

Additional Information

If you encounter unfamiliar Excel terms or concepts, you can refer to Excel’s official documentation or resources like Microsoft’s Excel Glossary for further clarification.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.