Parabola
How it WorksWho it's ForFeaturesExamplesLearn
Y

Converting columns into rows

Convert rows with columns into multiple row entries, stacking all of the values into a single column.

Converting columns into rows

Objective

When you have a table of summarized data across multiple columns you may want to convert it back to individual line items (e.g. one row per data-point). Also, sometimes you want to take multiple columns of data, and line them up as a single column, with an additional column that shows which column the data point originally came from. This is especially useful when try to apply an operation to multiple columns at once.

Solution

Use an “Unpivot” object to select columns and rotate them back into rows. The column headers will be placed into one column, and the values will be placed in an adjacent column

Start automating with Parabola
Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.