How to Use TRANSPOSE Function in Excel

In this Excel Function Explained video series, I will explain, how to use TRANSPOSE function in excel. Excel TRANSPOSE function is used to change the position of data. Suppose you have a column of data and you need to convert or move it to row or vice versa then you can use this function.

This is an Array function and it works differently then any normal function. Array functions are function that are used for complex calculations. These calculations are different and cannot performed by standard worksheet functions. Also array functions may sometimes require multiple cells to display results and does it automatically.

In short if a formula is applied to more than one cell is an array formula.

Let’s learn how to use TRANSPOSE formula in excel.

The Function looks like this =TRANSPOSE(Array)

The TRANSPOSE function has Only one argument or parameter and that is explained below.

1. Array: Here you need to specify the array or data range. This is where you specify the data range that you need to transpose.

How to apply Transpose Function to convert vertical data into horizontal?
Unless you are using office 365 you need to select the data range mating the number of cells you are going to transpose. Suppose you have data in Cell A1 to Cell B5. That means you have two columns and five rows of data. Now before using this function you need to select Two rows and five columns where you are going to place the new data. You can see here number of cells are exact same but the orientation is different.

Now while selected write the function. Then select the array or data range that you need to move. Now don’t press ENTER; instead press CTRL+SHIFT+ENTER and done.

Now if you need to use Transpose Function to convert horizontal data into vertical, you can do that using the procedure stated above.

This is how we use TRANSPOSE in excel. Remember, using TRANSPOSE function in excel you actually tell excel formula to convert rows into column or vise versa.

#Excel #Function #TRANSPOSE

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[tejaswijakkan]

Excellent Nicely you have Explained Thanks