Updated Improved Version https://www.youtube.com/watch?v=s-I8Z4nTDak
Learn how to assign data validation using Apps Scripts and create dynamic dependent dropdown lists for the whole column for Google Sheets.