Transpose a Table

Transposes a given table.

Overview

This procedure transposes a given table. It flips the table's rows to columns and the columns to rows. This may be useful when you want to view or work with your data from a different angle. For example, turning a list of dates in a column into headers across the top, or switching the focus from categories to individual entries.

Input Concepts

Concept	Type	Description	Default	Required
table	table	The table to transpose	No default	Yes
index column	text	The name of the index column for the transposed table	No default	No
new column names	text	New names for the transposed columns	No default	No

Output Concepts

Concept	Description
table	The updated table after transposing.

Examples

1. Transpose an Table

Automation

create an integer table
transpose the table

Results

0	1	index
100	200	Amt
10	5	Min
300	500	Max

2. Transpose a Table Using Optional Arguments

Automation

create a sample table
transpose the table where
    the index column is "Name"
    the new column names are "A1", "A2", "A3"

Results

A1	A2	A3
+ 1 [phone]	123 east street	San Francisco
+ 1 [phone]	321 west street	San Jose
+ 1 [phone]	213 north street	San Francisco