Uploaded July 2018 | Updated September 2026, 1 hour ago

---

Our weekly data isn't in the correct layout. We can't do a simple vlookup!
myspreadsheetlab.com/data-disaster-non-normalized-data-in-excel
00:00 challenge explanation
01:00 our options
02:19 Step1 create named range
02:45 Step2 verify assumption
03:36 Step3 which column?
04:50 Step4 which row?
05:31 Step5 binning table
06:07 Step6 manager row
07:55 Step7 employee's manager!