Help Centre

Swing Down

About Swing Down

Swing Down transposes the headers of selected columns into rows in a new column and collects their values into another new column. These columns are appended to the right of the dataset and the original columns are removed. For every row in the input data, each Swing Down Column will create a new row in the output.

Example

Swing Down is useful for dealing with tables where data categories have been split out into separate columns. The categories and values need to be ‘flattened’ into a pair of columns to enable reporting, querying or processing downstream.

Input data
Company
2019 Revenue
Swing Down Column
2020 Revenue
Swing Down Column
Acme
100
120
NewCo
200
220
Output data
Company
Year
Header Column
Revenue
Value Column
Acme
2019 Revenue
100
Acme
2020 Revenue
120
NewCo
2019 Revenue
200
NewCo
2020 Revenue
220

Using Swing Down

  1. Select ‘Swing Down’ from the Transform category in the operations menu.
  2. Select one or more Swing Down Columns. The headers for these columns will be transposed as rows in the Header Column.
  3. Name the Header Column.
  4. Name the Value Column. This column collects all the values from the Swing Down Columns.