Excel Search In Data Validation List (Searchable Drop Down List)

The Column Converting To Rows (With VBA Code) 

We split the data in  A column to rows  (each row will have thirty data).