Drop down list in excel can help you to prepare clean data
Excel Multiple Dropdown. In the data validation dialogue box, within the settings tab, select ‘list’ as validation.
In the data validation dialogue box, within the settings tab, select ‘list’ as validation.
In the data validation dialogue box, within the settings tab, select ‘list’ as validation. In the data validation dialogue box, within the settings tab, select ‘list’ as validation.
