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

create an integer table
transpose the table

2. Transpose a Table Using Optional Arguments

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

Last updated

Was this helpful?