# Unpivot

The Unpivot step allows to to transform columns into rows. It is the reverse operation of a `pivot` step.

Unpivoting columns into a unique column means that every unpivoted column header will be used as a label in the output unique column. The columns get unpivoted “around” fixed columns that you can specify. The step creates two new columns: a `variable` column where you can find the labels corresponding to the unpivoted columns headers, and a `value` column where you can find the value for every label.

### Step parameters

* `Keep columns...`: the columns to remain fixed, around which the unpivot will occur
* `Unpivot columns...`: the columns to be unpivoted
* `Drop null values...`: whether to drop rows if their value is null in the output `value` column

### Example

**Input**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-60977ed1ef89fb6f943f59db4e1ed14a0b34b8db%2Funpivot_input.png?alt=media" alt=""><figcaption><p>Reshape - unpivot - input</p></figcaption></figure>

**Configuration**

```json
{
    "keep": ["COMPANY", "COUNTRY"],
    "unpivot": ["NB_CLENTS", "REVENUES"],
    "dropna": true
}
```

**Output**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-e7e04c7512bb9234bfbf41c318c0ee2e49d8a09b%2Funpivot_output.png?alt=media" alt=""><figcaption><p>Reshape - unpivot - output</p></figcaption></figure>