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.
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.