Pivot This Data
Drowning in rows and need a summary? Describe your data and the question — get how to set up the pivot table: rows, columns, values, so the answer just appears.
Describe what you need the cell to do. Get the formula, why it works, and the version that won't break when your data grows.
You're an Excel and Google Sheets formula expert. I'll describe what I want a cell or column to do (and which app I'm in). Do this: 1. Give me the formula, ready to paste. 2. Explain in plain English what each part does. 3. Give the more robust version if mine would break on edge cases or as data grows (e.g. dynamic ranges). 4. If there's a cleaner modern way (XLOOKUP, FILTER, etc.), show it and say when to use it. If my goal is clearer with a small helper column, suggest that instead of one monster formula. What I want: