Pivot Table Builder

Specifies and builds a pivot table from a flat data range, choosing rows, columns, values, and filters. Use it when you have raw tabular data and need a summary view without building it cell by cell.

AAndrew Oria·Finants·MIT

Kogu oskus — vaikeversiooni hoitakse GitHubis; sinu muudatused jäävad sinu enda klooni.

Kuidas see töötab?

ChatGPT avab uue vestluse, kuhu oskus on laaditud. Kui see on lingi jaoks liiga pikk, kopeeritakse see lõikelauale — lihtsalt kleebi.
Claude töötab samamoodi. Püsivaks paigaldamiseks laadi alla .zip ja lae see üles: Claude → Settings → Capabilities → Skills (Pro/Team/Enterprise).
Kopeeri prompt kopeerib oskuse, et saaksid selle kleepida mis tahes assistenti, sh Grok.

Pivot Table Builder

When to use

Use this when you have a flat data range, one row per record, and need a summarized view by category, time period, or segment, and would rather describe the summary you want than build the pivot table manually.

Instructions

Confirm the data range is genuinely flat: one header row, no merged cells, no subtotal rows mixed into the data.
Ask what question the summary needs to answer if it is not stated, since that decides which fields go where.
Propose the pivot table layout: which field goes to Rows, which to Columns, which to Values (and the aggregation, sum, count, or average), and any Filters.
Build the pivot table with that layout.
Flag any field that will not aggregate cleanly, for example a text column dropped into Values by mistake.

Example prompts

"Use the pivot-table-builder skill to summarize this sales data by region and month."
"Build a pivot showing headcount by department and level from this raw HR export."

Output

A pivot table specification (rows, columns, values, filters) and the built pivot table on the worksheet, with a one-line note on what it answers.