0 Replies Latest reply: Jul 31, 2017 5:33 PM by Neill Carson RSS

    Crosstable/For loop Question

    Neill Carson

      Hi everyone, I have a big table consisting of multiple header items that i need to consolidate by months. I know I can do this in several ways, but my code is long and manual and I was hoping one of the geniuses here could help me learn a better way.

       

      My table has the following fields.

      ID

      Name

      Title

      SalesAug

      SalesSep

      SalesOct

      SalesNov

      SalesDec

      SalesJan
      SalesFeb

      SalesMar

      SalesMay

      SalesJun

      SalesJul

      HoursAug

      HoursSep

      HoursOct

      HoursNov

      HoursDec

      HoursJan
      HoursFeb

      HoursMar

      HoursMay

      HoursJun

      HoursJul

      BonusAug

      BonusSep

      BonusOct

      BonusNov

      BonusDec

      BonusJan
      BonusFeb

      BonusMar

      BonusMay

      BonusJun

      BonusJul

      Is there a clean way I can make this into a table with the following fields:

      ID

      Name

      Title

      Month

      Sales

      Hours

      Bonus

      Any help is appreciated