00176 Normalize & Pivot Taco Orders
www.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