Convert column values into rows

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:

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




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.

Last updated