Having trouble separating items into three separate columns using Text To Columns

[booleanboolean]

https://imgur.com/a/FWGxVXT

Please refer to image above. I basically need to separate these items into three columns (Item Number, Item Name, and Screen Number) from the date in columns A and B.

The trouble I am having is that there are about 30,000 line items and some of them are clustered like so: https://imgur.com/a/DCpSvPO

How would I do this in order to extract the data from the left into their respective columns in I, K, and M?

Thanks in advance,

BB

 

[sandy666]

post a link to the shared representative example excel file (not a picture) with raw data and expected result
don't use any formatting on the sheet, eg. white background or similar
btw. read my footnote