1 Reply Latest reply: Mar 4, 2016 5:00 PM by Sinan Ozdemir RSS

    Import multiple excel files with columns different

    Graziano Grasso

      Hi,

      I have many excel files, one per month , relating to sales of products in various outlets.

      Within each file I have several columns , the first two columns are present in all files , from the third column are the products . Unfortunately , they do not always match the columns of products . I make a brief example :


      PV001201501.XLSX

       

      departmentART1ART2ART..n
      0011022nn
      002510nn
      003410nn


      PV001201502.XLSX

       

      departmentART3ART4ART..n
      001510nn
      00275nn
      00374nn


      PV001201503.XLSX

       

      departmentART1ART3ART..nn
      001105nn
      00254nn
      003510nn


      I would get a standard table

      DepartmentART1ART2ART3
      001202210
      002101011
      0039017


      how can it get?

      Thank you!