TRANSPOSE FUNCTION

Transpose function is a very useful function and it is used to transpose a data which is in a column to a raw or vice versa .Ie,it help to transpose a selected array.

The TRANSPOSE function should be entered as an array formula in a range that has the same number of rows and columns that equals the number of columns and rows of the source array respectively.

Syntax

={Transpose(Array) }

Array - the range of cells to be copied from a row into a column or from a column into a row

The curly braces " { } " surrounding the function indicate that it is an array formula.

Press "Shift + Ctrl+ Enter" to make the curly braces {}.

Example


We have a list of  Engineering branches and all the entries here are vertical entries  or they In a same column .We want to change that into same  rows /In a horizontal line .





Select C9: G9 and Type the below mentioned Transpose formula .After typing the formula please Press "SHIFT+CTRL+ENTER" to make the formula into an array formula .

The Result Is 

Note : If you use Transpose In Paste special It just Transpose the Value but Transpose function is used for  transposing the Cell Value/Equation 

4 comments:

  1. I am not able to do this. Some unexpected error is getting pop-up when {}is used

    ReplyDelete
    Replies
    1. Step 1:Please select the cells you want to display the result .Make sure that it should equal to the number of text cells you want to transpose
      Step 2 :Type =transpose(array) press "CTRL+Shift+Enter"

      Please try this out again .If error is cmg again pls sent me that excel sheet to my email toofficeexpert@gmail.com
      Thank You
      Justin thomas

      Delete
  2. Thanks for the information. In between if we right click and select "paste special values" the same option Transpose is displayed there. Is this the same?

    ReplyDelete
    Replies
    1. It is the same but you need to right click every time when you change the data in the cell .But if you use function then it will automatically change when u change the data in any cell...

      Delete