Uploaded April 2018 | Updated September 2026, 3 hours ago

---

myspreadsheetlab.com/excel-pivot-tables-analyze-taco-data
00:00 Tacombi.com tacos!!
00:14 Menu orders not normalized
00:46 Our scenario (analyze the data)
01:22 What we need to do (before pivot)
02:42 Solution A array formula etc
04:16 Solution B helper formulas
06:11 Solution C Get & Transform
07:31 Solution D quick and dirty
08:12 Pivot Table samples
08:41 Learn Pivot Tables, Get & Transform