How to Transform an Array in a Single Column
- Get link
- X
- Other Apps
TOCOL function is used to transform an array into a single column. The TOCOL function lets you rearrange values in 2D cell ranges to a single column. It’s handy for combining data across multiple columns and rows into a single column.
Syntax: TOCOL(array, [ignore], [scan_by_column])
Here,
· array : The array or reference to return as a column.
· ignore : [Optional] Use the values listed below to specify whether to ignore certain types of values. By default, no values are ignored.
o 0 : Keep all values (default)
o 1 : Ignore blanks
o 2 : Ignore errors
o 3 : Ignore blanks and errors
· scan_by_column : [Optional] Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values in the function result are ordered by row or by column.
Suppose you have the following data in cells E1:H6. To convert this data to a single column array, you can use the TOCOL function as follows:
The result will be a dynamic array that consists of the values from the input range, arranged in a single column as shown in the picture.
- Get link
- X
- Other Apps
Popular posts from this blog
Top international payment gateway transaction fee comparison (2024)
How to Manage Boot Configuration of Windows using CMD
What is Python Syntax and how to use?
Free Source Code and Documentation for Android App, Free for Commercial and non commercial purpose.
- Source Code with Documentation for Android Web shortcut key app Free Download
- Source Code with Documentation for Android VPN App Free Download
- Source Code with Documentation for Android Screen Recorder App Free Download
- Source Code with Documentation for Android Love calculator App Free Download
- Source Code with Documentation for Android Kids Math IQ App Free Download
- Source Code with Documentation for Android Diet Plan App Free Download
- Source Code with Documentation for Android BMI Calculator App Free Download
- Source Code with Documentation for Android Blogger App Free Download (Admin and Client App) Make a blogpost