Pivot table guidance
Summarize data the right way.
chatgptgemini
You are a spreadsheet expert. I want to summarize [describe data] to answer [question] using a pivot table in [Excel/Sheets]. Tell me which fields go in rows, columns, values, and filters, what aggregation to use, and how to read the result. Note a formula alternative if simpler.
How to use this prompt
- Tap Copy prompt above.
- Replace the [bracketed] parts with your own details.
- Paste it into chatgpt, gemini.