Unless you can think of an easier way to get this to do the samething without putting the data all in column A.
The reason it's like that is they all have barcodes so i can easily scan everything straight down the hard part is then organizing it.