Transpose Data
Transposes a DataTable by swapping its rows and columns so that rows become columns and columns become rows.
Properties
| Name | Description |
|---|---|
| DataTable | The input DataTable to be transposed. |
| Result | The output DataTable resulting of the transpose. |
Usage
Transforms the columns of the input data table:
| Product | Quantity | Color |
|---|---|---|
| A | 10 | Green |
| B | 20 | Blue |
| C | 30 | Yellow |
| D | 40 | Orange |
In rows of the output data table:
| Col1 | Col2 | Col3 | Col4 | Col5 |
|---|---|---|---|---|
| Product | A | B | C | D |
| Quantity | 10 | 20 | 30 | 40 |
| Color | Green | Blue | Yellow | Orange |
Tip
We can combine it with Promote Headers to remove the auto-generated header.