TRANSPOSE Function in Excel: Explained
In this article, you will learn how to use the TRANSPOSE formula in Excel.
What is the TRANSPOSE formula in Excel?
The TRANSPOSE function is used to return a vertical set of data points as a horizontal set, or vice versa. The data is entered as an array of cells either vertically or horizontally.
How to use the TRANSPOSE formula in Excel
- Select the cell where you want to display the outcome.
- Type the following formula into the cell: =TRANSPOSE(
- Enter the range of cells (array) after the open parenthesis and then close the parenthesis.
- Now press CTRL+SHIFT+ENTER (this is important!)
- The result should be displayed with orientation of the dataset now flipped.
Syntax:
See below for how the formula is used:-
Case 1: When you have a set of data (single dimension) horizontally which you want to display vertically.
![](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/64371918dd15d749ab6cbd9c_uyGNBBu8EIUGdYo0fQSw6GHi9vdUzCQGCK8wEcy-avVmVklaCe1F8FWM_QbhXIXk85uMBrQ2gj6Z38sJFEr28C3il-91ddHDKDjyXEMLGMzc68mzl6Hj71KJ-4H8Gi1Pslx4AMs-5rYr3B2YCWxzNns.png)
Case 2: If you have the data in a tabular format where you may want to display the columns as rows or vice versa.
![](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/64371959c564671e87869f35_43YxOLXKLW_9FzVh8xKlLOXuPEaqBmhy_z0ijbCfe3bY9BAilul-8srgdxR2Gocz2JuBUjdJRUrOgYsASavwPoouO5PC_DhjcAGtj6JsU5WuUVyQ2gAOW1Pezgv6eHbIglF2GqTqoMhr2r0MV9G10Q.png)