MoneyWorks Manual
Transpose (table)
Result Type: Tab/newline delimited table
Definition: Transposes a tab/newline delimited table. This is useful to convert a table that has series data in rows—such as the results of the Analyse function—to one that has series data in columns, which is the format required for chart data. You can also use it if you need to use Head and Tail on columns—transpose the table so that columns become rows; now you can use Head or Tail to get the rows you want; Transpose back again.
Examples: Transpose ("A\tB\tC\nD\tE\tF\n")
returns "A\tD\nB\tE\nC\tF\n"
i.e this table
| A | B | C |
| D | E | F |
transposes to:
| A | D |
| B | E |
| C | F |
See Also:
CreateTable: Create an empty accumulator table
Sort: Sort a delimited tabular string
TableAccumulate: Accumulate numeric column data for a key
TableAccumulateColumn: Accumulate data in one column for a key
TableFind: Look up a key in the table
TableGet: Extract data for a key or index found with TableFind