Dataset Transform Tools

Pivot Table

Build a pivot table from tabular data - group records by row and column fields and aggregate values with count, sum, average, minimum, or maximum.

city,total

Riga,10

Riga,15

city · sum(total)

Riga · 25

Rename Columns

Rename selected CSV column headers using an explicit old-to-new mapping, with missing-source and collision detection, a preview, and export - column order and cell values are untouched.

first_name,age

Ada,36

name,age

Ada,36

Transpose Table

Swap rows and columns of a rectangular or ragged table - with control over header treatment, padding, and blank cells.

name,age

Ada,36

name,Ada

age,36

Unpivot Table

Convert selected wide columns into long-format attribute/value records - choose identifier columns, preserve row identity, and handle blanks and repeated headers.

id,Jan,Feb

A,10,12

id,month,value

A,Jan,10

A,Feb,12