> ## 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: Pivot Transformation

> Use the Pivot transformation to transpose rows into columns, converting unique field values into separate output columns in ETL pipelines.

The Pivot transformation transposes rows into columns, converting unique values from one field into separate output columns.

## Overview

* Converts row-level values into column headers
* Requires a group-by field, a pivot field (whose values become columns), and a value field
* Applies an aggregation function when multiple values exist for the same group/pivot combination

## Configuration

<Steps>
  <Step>Select the group-by field(s) -- these define each output row.</Step>
  <Step>Select the pivot field -- unique values in this field become new columns.</Step>
  <Step>Select the value field -- the data that populates the new columns.</Step>
  <Step>Choose an aggregation function (SUM, COUNT, AVG, MIN, MAX) for cases where multiple values exist.</Step>
</Steps>

## Example

Input with fields: `Region`, `Quarter`, `Revenue`.

Pivot on `Quarter`, group by `Region`, aggregate `Revenue` with SUM.

Result: one row per Region with columns Q1, Q2, Q3, Q4 containing revenue totals.