booleanboolean
New Member
- Joined
- Feb 25, 2017
- Messages
- 37
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
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