Google Sheets | TOCOL | Function | Formula | Example | How To | Spreadsheet | Tutorial
The Google Sheets TOCOL function converts one or more rows, spanning one or more columns into one row. The number of arguments of TOCOL is three. Of these three the first argument is mandatory.
=====================================
Food & Health Series Using 2D Animation
All the Parts of How to Prevent Diabetes series is based on research findings.
How to Prevent Diabetes Part 1
• How to Prevent Diabetes Part 1 | A Si...
How to Prevent Diabetes Part 2
• How to Prevent Diabetes Part 2 | Bitt...
How to Prevent Diabetes Part 3
• How to Prevent Diabetes Part 3 | Simp...
How to Prevent Diabetes Part 4
• How to Prevent Diabetes Part 4 | One ...
How to Prevent Diabetes Part 5
• How to Prevent Diabetes Part 5 | What...
=====================================
-------------------------------------
How to Use FACT and FACTDOUBLE in Google Sheets?
Use FACT and FACTDOUBLE to get the factorial and double factorial of a number:
• Google Sheets | FACT | FACTDOUBLE | F...
-------------------------------------
How to Use PERMUT and COMBIN in Google Sheets?
Get the permutations and combinations of n objects:
• Google Sheets | PERMUT | COMBIN | Fun...
-------------------------------------
How to Use SUMSQ in Google Sheets?
Use SUMSQ function to calculate the sum of squares of n numbers:
• Google Sheets | SUMSQ | Function | Re...
-------------------------------------
How to Use SUMIFS in Google Sheets?
Use SUMIFS to add numbers based on two or more conditions:
• Google Sheets SUMIFS Function | Sum N...
-------------------------------------
How to Use XLOOKUP for Reverse Search in Google Sheets?
XLOOKUP can search for the search key in the regular or reverse order in the lookup range:
• Google Sheets | XLOOKUP | Function | ...
-------------------------------------
How to Use LAMBDA and BYCOL in Google Sheets?
Create and test your own function using LAMBDA, and then use your function in a function like BYCOL:
• Google Sheets | LAMBDA | BYCOL | Func...
-------------------------------------
How to Use XMATCH in Google Sheets?
XMATCH returns the position of the specified search key in a row or column:
• Google Sheets | XMATCH | Function | E...
-------------------------------------
TOCOL Function Formula
=TOCOL(array_or_range, [ignore], [scan_by_column])
Start the formula with an equal-to symbol.
TOCOL is the name of the function.
array_or_range is one or more columns of values.
ignore is optional and its value either ignores or keeps blanks and errors.
Values of ignore are: 0, the default value, keeps blanks and errors; 1 ignores only blanks; 2 ignores only errors, and 3 ignores blanks and errors.
scan_by_column is optional and its value scans the array by column or row.
Values of scan_by_column are: FALSE. It is the default value and scans the array by row; TRUE. It scans the array by column.
Examples
Example 1
Say cells A2, B2, A3, B3, A4, B4 each have the values Section A, Section B, Section C, 30, 38, 34 respectively.
The TOCOL function formula
=TOCOL(A2:B4)
will return a single column of values as
Section A
30
Section B
38
Section C
34
Example 2
Consider the same data as in the above example. Assume that the value in cell B3 is blank and not 38 as in the above example.
The TOCOL function formula
=TOCOL(A2:B4,1)
with the value of 1, for ignore argument, ignores the blank cell, B3, and returns a single column of values as:
Section A
30
Section B
Section C
34
Example 3
Consider the same data as in Example 1 again.
The TOCOL function formula
=TOCOL(A3:C4,,TRUE)
which specifies the default value of 0 for ignore argument, and TRUE for scan_by_column argument, returns a single column of values as:
Section A
Section B
Section C
30
38
34
Take a look at this video tutorial, which gives the steps to use the Google Sheets TOCOL function with examples.