> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Transpose

> Convert columns to rows

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.

<img className="rounded-md" src="https://mintcdn.com/less-51/am-71qiho-NViN_t/images/tools/transpose/Illustration.png?fit=max&auto=format&n=am-71qiho-NViN_t&q=85&s=6491b362af39ce396539dd10aea941f6" width="1576" height="660" data-path="images/tools/transpose/Illustration.png" />

<Note>
  The Transpose tool more or less does the reverse of the [Pivot](/tools/reshape/pivot) tool
</Note>

<Tip>
  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.
</Tip>

### Configuration

<Steps>
  <Step title="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.
  </Step>

  <Step title="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.
  </Step>

  <Step title="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.
  </Step>

  <Step title="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.
  </Step>
</Steps>

### Example: The illustration example 👆

<Frame>
  <img className="rounded-md" src="https://mintcdn.com/less-51/tvKC10PJfN6EkkU2/images/tools/transpose/IllustrationExample.gif?s=f49d3c9e7adf3cd5b2b252de9baa4b22" width="2000" height="1243" data-path="images/tools/transpose/IllustrationExample.gif" />
</Frame>
