All the batch numbers are in column 4. They are 'missing' ie need to be entered into column 1. Perhaps missing was a wrong choice of word. Required maybe?
The data comes from two sources, thats the problem. They need to be brought together at this point.
regards
The Doc