00179 Data Disaster non normalized data
Our weekly data isn't in the correct layout. We can't do a simple vlookup!
https://www.myspreadsheetlab.com/data...
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!