writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − − + − Line 55:
Line 53: − +
Manuals/calci/TRANSPOSE (view source)
Revision as of 06:44, 5 February 2014
, 06:44, 5 February 2014no edit summary
<div style="font-size:30px">'''TRANSPOSE(ar)'''</div><br/>
<div style="font-size:30px">'''TRANSPOSE(ar)'''</div><br/>
*<math>ar </math> is the array of values to transpose.
*<math>ar </math> is the array of values to transpose.
==Description==
==Description==
*This function is used to copy the data displaying in vertical order in to a horizontal order or copy the data displaying in horizontal order in to a vertical order.
*This function is used to copy the data displaying in vertical order in to a horizontal order or copy the data displaying in horizontal order in to a vertical order.
*In <math> TRANSPOSE(ar), ar </math> is the range of cells to be transfer from column in to a row or row in to a column.
*In <math> TRANSPOSE(ar)</math>, <math>ar </math> is the range of cells to be transfer from column in to a row or row in to a column.
*The result as a horizontal range of cells if a vertical range of cell is given as a argument.
*The result as a horizontal range of cells if a vertical range of cell is given as a argument.
*The result as a vertical range of cells if a horizontal range of cell is given as a argument.
*The result as a vertical range of cells if a horizontal range of cell is given as a argument.
==Examples==
==Examples==
*[[Manuals/calci/MINVERSE | MINVERSE ]]
*[[Manuals/calci/MINVERSE | MINVERSE ]]
*[[Manuals/calci/MMULT | MMULT ]]
*[[Manuals/calci/MMULT | MMULT ]]
==References==
==References==
[http://en.wikipedia.org/wiki/Transpose Transpose ]