- Picture and text skills
- Case
Returns the transposed cell range, that is, transposes a row of cell range into a column of cell range and vice versa. The number of rows and columns is the same as that of [url=]array[/url]
In areas with the same number of rows and columns, TRANSPOSE must be entered as [url=]array formula[/url]. Use TRANSPOSE to transpose in a worksheet
The vertical and horizontal directions of the array.
Syntax
TRANSPOSE(array)
Array The array or cell range in the worksheet that needs to be transposed.
The so-called transposition of an array is to use the first row of the array as the first column of the new array,The second row of the array as the second column of the new array columns, and so on.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/cha-zhao-he-yin-yong-han-shu-TRANSPOSE-han-shu-zhuan-zhi-biao-ge-heng-xing-shu-lie.html
支付宝扫一扫 
评论列表（196条）
测试