# The Pivot Recipe[¶](https://knowledge.dataiku.com/latest/courses/visual-recipes/pivot/index.html#the-pivot-recipe "Permalink to this headline")

Although the Prepare recipe includes a pivot processor, the Pivot recipe allows you to transform rows into columns with greater control and more customized aggregations. The Pivot recipe can also execute the pivot natively on external systems, such as SQL databases or Hive.

The Core Concepts have already introduced the mechanics of the Pivot recipe.

The following tutorials go into greater detail — whether you only need to pivot values or pivot and perform an aggregation, as in a pivot table.

## Lessons[¶](https://knowledge.dataiku.com/latest/courses/visual-recipes/pivot/index.html#lessons "Permalink to this headline")

* Hands-On Tutorial: Reshaping Data from Long to Wide Format

* Hands-On Tutorial: Creating Excel-Style Pivot Tables with the Pivot Recipe
