Nov-15-2021, 07:25 PM
Looking at the data, first 6 lines alternate between number and description. Then you get 2 lines of description which is going to be problematic. If you try to filter by if numbers only it is the code, then one of the codes has a "C" in it which again is a problem.
You need to be able to describe how the program is to distinguish the columns, then you can try to program it.
You need to be able to describe how the program is to distinguish the columns, then you can try to program it.