00180 Data Disaster GET & TRANSFORM solution
https://www.myspreadsheetlab.com/norm...
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 !
www.myspreadsheetlab.com/learning-power-query-get-transform/
*****************************