I have a table with sequences of numbers that are essentially the same except for the leading digits. The idea is a "10" indicates a case and the "00" indicates an item number. I have to create an XLS file with the two numbers in individual columns instead of rows and tack on the descripiton. Essentially like this:
UPC Item Case Desc 05555 0005555 1005555 Hotdogs 02345 0002345 1002345 Hamburgers To: UPC Item Code Case Code Description 05555 0005555 1005555 Hot dogs 02345 0002345 1002345 Hamburgers and so forth. For some reason this is just baffling me. I know it's probably really simple, but I just don't get it. Can anyone help? Thanks. Ray. ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
