TRANSPOSE (PQL - xl)

This function returns a vertical range of cells as a horizontal range or a horizontal range of cells as a vertical range

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

Syntax

TRANSPOSE(array)

Function Arguments

Name

Description

Type

Optional

array

The array argument is a range of cells or an array that you want to switch

StringOrNumber

Comments

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