24 Replies Latest reply: Feb 23, 2015 8:48 AM by Friedrich Hofmann RSS

    Loading an Excel list (export from ?somewhere?) with 2-line records

    Friedrich Hofmann


      Hi,

       

      I have to do a simple vlookup between two tables in Excel.

      Simple enough.

      The remaining hurdle is: The one Excel_file (from where I have to fetch a value if there is any) has 2-line records - and

      I need

      - the item_nr. from the 1st line of every record

      - the BIN nr. from the 2nd line of every record

       

      => So I cannot use a WHERE ISNUM to filter for just the lines with item_numbers for then all the BIN_numbers would not be connected.

       

      Can anyone help me on this?

      Thanks a lot!

      Best regards,

       

      DataNibbler

       

      P.S.: I cannot use the logic that all odd-numbered lines have an item_nr. and the even-numbered have a BIN_number and then JOIN them because sometimes there are several lines for one item_nr., so that can vary.