2 Replies Latest reply on Dec 12, 2012 2:03 AM by Geoffroy Magnan

    Importing Excel files containing the same measure for different years ?

    Geoffroy Magnan

      Is there way to import data presented as following in an Excel table :

      GenderJob
      201020112012
      FClass 1100011001200
      FClass 2300031003300
      MClass 1etc...

      MClass 2


       

      The "solution" I used was to recreate the individual "records" by copying the value of each year in records below the others, to obtain a table like this :

      GenderJobYearSalary
      FClass 120101000
      FClass 220103000
      FClass 120111100
      FClass 220113100

       

      As I don't have the data source but use publicly available data, I can only access the first kind of table and not the raw data. Finding a work-around or another approach would be great !

       

      G. Magnan