I don’t often do this*, but I recently got a question on my YouTube tutorial, Update dropdown list in Google Sheets dynamically based on previous dropdown choice: Data Validation, about whether or not this process can be applied to a column range.
The short answer is yes. The long answer is that it is a bit ugly, but it works.
Let’s first clarify the problem.
*obviously not procrastinating before starting another big project 🤣🐐.