TransposeArray
The TransposeArray() function returns the transpose of a data range—vertical columns become horizontal rows and vice versa.
Related functions: ArrayToString, StringToArray, SubstituteArray
Syntax:
Qx.TransposeArray(Range)- In Excel with Quintessence add-in versions prior to 25.1, use:
TransposeArray() - In the Quintessence Editor (Studio) using Quintessence language, use:
TransposeArray() - In the Quintessence Editor (Studio) using Python language, use:
Qx.TransposeArray()
ⓘ See parameter descriptions
| Range | The string to be split. |
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Transposing multiple columns
Range (A1:B5):
| Task 1 | 10% |
| Task 2 | 99% |
| Task 3 | 100% |
| Task 4 | 45% |
| Task 5 | 85% |
Function call:
=Qx.TransposeArray(A1:B5)Result:
| Task 1 | Task 2 | Task 3 | Task 4 | Task 5 |
| 10% | 99% | 100% | 45% | 85% |