# 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.

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