2 Replies Latest reply: Sep 24, 2012 4:14 AM by whiteline _ RSS

    Two structures in the same excel file

      Hi everybody, I have many excel files in a folder, the problem is that in this files, I have two different structures, I would like to load data from this files:

      Example:

       




      City ACity BCity CCity D
      ProduitCentreStock22283440
      aZIKXJr13333
      aZIKXJr24444
      aZIKXJr35555
      aZIKXJr46666
      aZIKXJr57777
      aZIKXJr68888
      aZIKXJr79999
      aZIKXJr810101010
      aZIKXJr911111111
      aZIKXJr1012121212
      aZIKXJr1113131313
      aZIKXJr1214141414
      aZIKXJr1315151515
      bZIKXStock16161616
      bZIKXJr116161616
      bZIKXJr217171717
      bZIKXJr318181818
      bZIKXJr419191919
      bZIKXJr520202020
      bZIKXJr621212121
      bZIKXJr722222222
      bZIKXJr823232323
      bZIKXJr924242424
      bZIKXJr1025252525
      bZIKXJr1126262626
      bZIKXJr1227272727
      bZIKXJr1328282828

      The result that I would like to have is:

       

      ProduitCentreCityStockJr1Jr2Jr3Jr4Jr5Jr6Jr7Jr8Jr9Jr10Jr11Jr12Jr13
      aZIKXA223456789101112131415
      aZIKXB283456789101112131415
      aZIKXC343456789101112131415
      aZIKXD403456789101112131415
      bZIKXA1616171819202122232425262728
      bZIKXB1616171819202122232425262728
      bZIKXC1616171819202122232425262728
      bZIKXD1616171819202122232425262728

       

      Thank you.

      Zak