Unpivot
Convert column values into rows
Last updated
Convert column values into rows
Last updated
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:
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.
