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

    Combine csv header data into body of table

    Joe Kirwan



      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?