注意:此功能仅在Microsoft 365的Insider频道中的Excel可用。 TOCOL函数与TOROW函数对比 TOCOL函数可以用于将数组或范围转换为单列,而TOROW函数则可以将数组或范围转换为单行。 语法 =TOCOL(数组,[忽略],[按列扫描]) 参数 数组(必需):要转换为单列的数组。
In Excel versions where the TOCOL function is not supported, there exist a couple of alternative ways to transform a range of cells into a column. These solutions are quite tricky, but anyway working. To read the range by row: INDEX(range, QUOTIENT(ROW(A1)-1, COLUMNS(range))+1, MOD(R...
Excel TOCOL Function Examples We can use TOCOL to combine the data in cells C24:G27 into a single column: Notice the blanks have returned zero values. We can hide these with theignoreargument: And with thescan_by_columnargument, we can change the order of the result, to scan the input...
Returning the Top 3 Rows with the TAKE function In the previous examples, the source tables were not sorted. If we wanted to find the top three rows based on the highest salaries, we could use theSORTfunction to sort the table before extracting the rows. ...
You can instruct Excel as to how to compile the column through the optionalscan_by_columnargument. If this argument is included and set to TRUE, the function will add the values in a vertical order, column by column. If the argument is set to false or not included in the function, TOC...
注意:此函數僅在 Microsoft 365 的 Insider 頻道中的 Excel 可用。 TOCOL 函數與 TOROW 函數的比較 TOCOL 函數可用於將陣列或範圍轉換為單一欄位,而 TOROW 函數則可用於將陣列或範圍轉換為單一行。 語法 =TOCOL(陣列, [忽略], [按欄掃描]) 參數 陣列(必填):您想要轉換為單一欄位的陣列。 忽略(可選):用...