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) }
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
I am not able to do this. Some unexpected error is getting pop-up when {}is used
ReplyDeleteStep 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
DeleteStep 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
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?
ReplyDeleteIt 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