All pages
Powered by GitBook
1 of 1

Loading...

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

Output Concepts

Concept
Description

Examples

1. Transpose an Table

0
1
index

2. Transpose a Table Using Optional Arguments

A1
A2
A3

text

New names for the transposed columns

No default

No

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

table

The updated table after transposing.

100

200

Amt

10

5

Min

300

500

Max

+ 1 (415) 691 9426

123 east street

San Francisco

+ 1 (415) 691 1234

321 west street

San Jose

+ 1 (415) 691 4595

213 north street

San Francisco

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

new column names