TOCOL (PQL - xl)

This function returns the array in a single column

  • Library: PQL \ Spreadsheet \ Lookup
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

TOCOL(array, OPTIONAL ignore, OPTIONAL scan by column)

Function Arguments

Name

Description

Type

Optional

array

The array or reference to return as a column

StringOrNumber

ignore

Whether to ignore certain types of values. By default, no values are ignored

Number

Y

scan by column

Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column

StringOrNumber

Y

Comments

This function is the same as the Microsoft Excel 'TOCOL' function - using the same inputs, logic and outputs.