# Unpivot

Unpivot takes many columns in a table and lines them up into a single column called "value". A new column will be created called "variable", which holds the value of the column header in the original table.

<figure><img src="https://1817223046-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5mI0ilekQtcGTXKGQ2EF%2Fuploads%2FluZnTahfMd4sjvYIhL30%2FProperty%201%3DUnpivot.jpg?alt=media&#x26;token=86701166-72bb-4bb4-bf64-51c5f4f6d628" alt=""><figcaption></figcaption></figure>

For example, in a table with multiple value columns:

![](https://files.readme.io/829244e-New_Workbook.png)

Unpivot will create a narrower table with variable and value pairs:

![](https://files.readme.io/0f334eb-New_Workbook.png)

### Options

| Selection                           | Description                                                                                                 |
| ----------------------------------- | ----------------------------------------------------------------------------------------------------------- |
| **ID Columns**                      | The columns which should *not* be broken out into rows. Each unpivot tool needs at least one **ID column**. |
| **Variable Column Name** (optional) | The default name for the variable column is "variable". Fill this in to rename that column.                 |