How to Use Excel TOCOL Function?

Ads

Listen to this article.

Excel TOCOL Function: Sometimes, we want to convert the array of data into columns, we can manually do this by copying the values and pasting them on the specified cells to make a column. This is quite frustrating to you. For that, Microsoft Excel provides a built-in function called “TOCOL” for making it possible with a few clicks.

To use Excel TOCOL Function on your worksheet, refer to the below-given steps. You can easily apply this function and make a column using a range of input data in the spreadsheet. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Definition of TOCOL Function

It is one of the built-in functions in Microsoft Excel.
The TOCOL function transforms the given array into a single column in the worksheet.
By default, the TOCOL function will scan values by row. It can also scan values by column.

Syntax

Here, you will see the syntax of the TOCOL function.
To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
Once you enter the formula, click on the Enter button to get the result.

=TOCOL (array, ignore, scan_by_column)

Argument Explanation:

array – The array to transform.
ignore – Setting to ignore blanks and errors.
scan_by_column – Scan array by column. TRUE=column, FALSE=row (default=TRUE).

Examples

Let’s look at some practical examples of the TOCOL Function and explore how to use it in Microsoft Excel.

Initially, you have to open your Excel workbook on your PC and launch the worksheet with data.
For instance, we have given a range of values as shown in the below screenshot. And we will transform them into a column using TOCOL function.

Then, you have to enter the formula in the cell as shown below to get the result.

After entering the formula, you need to click the Enter button to get the output.

Conclusion

From this post, you can clearly understand how to use the Excel TOCOL function in the worksheet using its syntax. The given examples helped you to understand this function even easier. Drop your comments regarding this post in the below section. To learn more about Excel functions, then visit our webpage Aawexcel.com.