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:
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.
- 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)
- 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).
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.
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.
The following video will show you how to use the Excel TOCOL function in the spreadsheet.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?