Unique Data Validation drop-down from duplicate table data

In this post, we'll explore a method for generating a drop-down that contains a unique list of choices derived from a table column with duplicate values.

This technique involves creating a unique list in a worksheet with a PivotTable. The PivotTable is an intermediate step that creates a list that we can use to feed the data validation drop-down list.