Skip to main content
The Transpose tool doesn’t change your data, it simply reorganises it. It can help you restructure your data to reduce the need for additional tools.
The Transpose tool more or less does the reverse of the Pivot tool
The Transpose tool can be very useful before storing your data if you want to use filters/slicers in visualisation tools that select the metric instead of showing all metrics.

​
Configuration

1

Select Column(s) to Hold Constant

Select the column(s) to hold constant. You can imagine that the columns you select here will remain on rows.
2

Select Columns to Transform to Rows

Select the column you want to transform into columns. You can select as many columns as you need.As these are transpose you will get a Column and Value column consisting of the selected columns name and corresponding value.
3

Variable name

Select the column you want to transform into columns. You can select as many columns as you need.As these are transpose you will get a Column and Value column consisting of the selected columns name and corresponding value.
4

Value name

Select the column you want to transform into columns. You can select as many columns as you need.As these are transpose you will get a Column and Value column consisting of the selected columns name and corresponding value.

​
Example: The illustration example 👆