The Transpose transform lets you swap columns to rows and rows to columns.

Transform - Transpose
Transform - Transpose

The Transpose transform is available in Dundas BI 2.6 or later.

1. Input

The Transpose transform requires 1 input transform that has at least 1 column.

For example, the input could be a Tabular Select transform that corresponds to the following Excel sheet:

Input data: Excel sheet
Input data: Excel sheet

2. Configure

In the Transpose configuration dialog, the Elements representing the columns to be transposed into rows are listed. This list is read-only.

Enter the Number of Rows that will be transposed into columns (i.e., the number of input rows).

Set the New Header Element dropdown to the input column containing the values that will become the output column headings.

Transpose configuration dialog
Transpose configuration dialog

3. Output

The output of the Transpose transform is the swapping of columns to rows and rows to columns from the input data.

Data Preview shows transposed output
Data Preview shows transposed output

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri