- By column, top to bottom
- By row, left to right
The scan_by_column argument is a boolean value that controls how TOCOL reads values from the source array.
Academy ↓
Free ↓
Formulas > =TOCOL()
Description
How To Actually Use TOCOL() in Sheets
TOCOL(array_or_range, [ignore], [scan_by_column])
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the TOCOL() formula:
Generate a TOCOL() formula for your needs with AI
Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.
Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.
Better Sheets
Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.
Google Sheets Help
Google Sheets Courses
Google Sheet Templates and Tools
Google Sheet Add Ons