Uploaded July 2018 | Updated September 2026, 1 hour ago

---

myspreadsheetlab.com/normalize-data-using-excel-get-transform
00:00 Intro
00:26 Data layout disaster
01:03 Insert table
01:22 Add helper columns
-------------------------
GET & TRANSFORM
02:08 Load table
02:42 Normalize data
03:27 '2ManagerNames' only
04:01 3FINALOUTPUT employees only
04:44 Merge 3FINALOUTPUT & 2ManagerNames
06:47 Export 3FINALOUTPUT to table
Exiting GET & TRANSFORM
-------------------------
07:13 Finally...our simple vlookup!

*****************************
MY POWER QUERY JOURNEY !
myspreadsheetlab.com/learning-power-query-get-transform
*****************************