> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Unpivot Transformation

> Use the Unpivot transformation to transpose columns into rows, converting multiple columns into key-value pairs in your ETL data pipeline.

The Unpivot transformation transposes columns into rows, converting multiple columns into key-value pairs.

## Overview

* The reverse of Pivot -- converts columns back to rows
* Useful for normalizing wide tables into long format
* Produces two output fields: one for the column name and one for the value

## Configuration

<Steps>
  <Step>Select the columns to unpivot -- these become row values.</Step>
  <Step>Select the columns to keep as-is (passthrough fields).</Step>
  <Step>Name the output field for column names (e.g., "attribute").</Step>
  <Step>Name the output field for values (e.g., "value").</Step>
</Steps>

## Example

Input: `Region`, `Q1`, `Q2`, `Q3`, `Q4`.

Unpivot Q1--Q4.

Result: `Region`, `Quarter`, `Revenue` -- one row per region/quarter combination.