7 Replies Latest reply: Apr 13, 2012 11:13 AM by Marcus Persson RSS

    Combine csv header data into body of table

    Joe Kirwan

      Hi

       

      I have a stock movement report in csv format in following layout.

       

      TAS CSV Qry01.PNG

       

      The problem is the header in line 2 which contains the Item Code and Description for the movements shown (in cells.A2 and B2)

       

      If I load as shown, there will be no assocaition between the Item and the movement data.

       

      This layout repeats for each item on the stock movement file.

       

      I want the data to load as follows:

       

      TAS CSV Qry02.PNG

       

      Any ideas?