WRAPCOLS (PQL - xl)

This function wraps the provided row or column of values by columns after a specified number of elements to form a new array

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

Syntax

WRAPCOLS(vector, wrap count, OPTIONAL pad with)

Function Arguments

Name

Description

Type

Optional

vector

The vector or reference to wrap

StringOrNumber

wrap count

The maximum number of values for each column

Number

pad with

The value with which to pad. The default is #N/A

String

Y

Comments

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