0 Replies Latest reply: Jun 21, 2012 7:32 AM by gerrywhite RSS

    Excel Import/Cross table

      Hello

       

      I have about 40 spreadsheets in the following format which I need to import.

      I can write some VBA stuff but id like to do this in QV. I think Ill need some kind of Crosstable notion but Im not sure.

       

       

      DescriptionAgeQ1SalesStaffQ2SalesStaffQ3Sales ... ...
      Leeds24554323232343437676
      London3446434545423237676

       

       

      and I need something like

       

      DescriptionAgeQuarterSalesStaff

      Leeds

      214554323
      Leeds2223234343
      Leeds237676
      London31446434
      London3254542323

       

      The Q1/Q2 columns in my data were just sum(Sales+Staff) and so I dont need it.

       

      I've tried various rotations and things and not got too far. Any ideas? Ideally something step by step

       

      Attached is a skeleton of my data