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


transposes to:


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