Question: how to extract data from dropdown in excel?
Answer: Go to Data –> Data Validation.
In Data Validation dialogue box, select the Settings tab.
In Settings tab, select “List” in the drop down, and in 'Source' field, select the unique list of countries that we generated.
Click OK.