Pivot Table from an Apify Dataset - Values into Columns

Created by

Adam Pearce

Actor

Dataset Aggregate, Group By & Pivot

Spreadsheet-style pivot table from any dataset: one field becomes columns, cells filled with sums or counts, plus a grand-total row and Excel export.

Try for free

Dataset Aggregate, Group By & Pivotnerolabs/dataset-aggregate-pivot

Region

Orders

Total amount

Avg amount

Input

Data (inline)

orderId:1001+7

region:North+7

product:Widget+7

amount:$1,200.00+7

orderedAt:2026-07-03+7

Group by field(s):region

Pivot field (optional):product

Pivot value field (optional):amount

Pivot cell function:sum

Add a grand-total row:true

Export file formats:xlsx

Output fields

Region

Orders

Total amount

Avg amount

How it works

Sign up on Apify or log in

The Dataset Aggregate, Group By & Pivot Actor is ready to run with the inputs already set for "Pivot Table from an Apify Dataset - Values into Columns". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Pivot Table from an Apify Dataset - Values into Columns" task

The Dataset Aggregate, Group By & Pivot Actor will start running based on the input automatically. You can also change all the input fields, like data (inline), group by field(s), and more, to match your specific use case.

Receive the "Pivot Table from an Apify Dataset - Values into Columns" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as region, orders, total amount, and more.