Any Excel Gurus Here? I need some help

[King]

So im trying to sort data from a barcode scanner. It inputs into excel as numbers, just like a keyboard would. Right now, all values come into excel in the input column I created. What Im trying to do is sort each value in its own column so I can easily count how many times that value has been inputted. This way, all values of 1012011 will fall into the 101 column and so on. Any ideas on how to do this. I will appreciate any help or suggestions. Thanks