> ## Documentation Index
> Fetch the complete documentation index at: https://alphacastio.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# Unstack (Long to Wide)
> Pivot a long-format dataset to wide format, turning the values of an entity column into columns of their own.
Sooner or later you find the data you need, but not in the shape you need it — values that should be columns are rows, or the other way round. Transposing doesn't fix it, because the entity columns have to be preserved. **Unstack** and [Melt](/steps/melt-dataset) do.
**Unstack** goes from long to wide: the values of an entity column become new columns.
## Example
Start with some Yahoo Finance data. The tickers (Apple, Microsoft, Google and so on) are values inside a single `Ticker` column. Suppose you need them side by side as columns, and only want the closing price rather than open-high-low-close.
Each ticker now has its own column.
See the [example pipeline](https://www.alphacast.io/pipelines/2022-6-10-UYhLlh/view) for both directions in one place.
## Reversing it
To go back the other way, use [Melt (Wide to Long)](/steps/melt-dataset).
## Next steps
The inverse operation.
Join the reshaped data with another dataset.