The Transpose transform lets you swap columns to rows and rows to columns.
The Transpose transform is available in Dundas BI 2.6 or later.
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:
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.
The output of the Transpose transform is the swapping of columns to rows and rows to columns from the input data.