---
title: "Reshape, pivot and aggregate data in Strata | Oplema"
description: "Change the shape of a table in Strata: summarize by group, calculate running values, move values between rows and columns and expand rows into ranges."
url: "https://oplema.com/docs/strata/transform"
updated: "2026-11-04"
---

# Transform

Transform blocks change the shape of a table. Summarize by group, calculate running values, move values between rows and columns and expand rows into ranges.

**Learn these blocks in context:** [Build a report from a CSV export](https://oplema.com/learn/export-to-report); [Combine and reconcile data files](https://oplema.com/learn/many-sources); [Build and publish a dashboard](https://oplema.com/learn/table-to-dashboard)

## Blocks in this palette

- Calculate totals and counts by group.
- Calculate running totals and moving averages.
- Count rows and columns.
- Turn columns into rows.
- Turn row values into columns.
- Turn each row into a range of rows.

## Transform FAQs

**Should I use Transpose or Cross Tab?**

Transpose turns columns into rows. Cross Tab turns the values in a column into columns.

**Should I use Summarize or Rolling Calc?**

Summarize reduces a table to one row per group. Rolling Calc keeps every row and adds running values.

### Prepare your data. Build it in Strata.

Strata opens in your browser, with no account.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
