4 Replies Latest reply: Jul 27, 2011 11:38 AM by mrkachhia RSS

    DATA FROM ROW NEEDED IN COLUMN

       

      Dear All,

      I have below weekly data for daily sale on different product.

       

      Product ID18/07/201119/07/201120/07/201121/07/201122/07/201123/07/2011TOTAL QTY SOLDTOTAL QTY REORDEREDTOTAL QTY NEED TO ORDER
      ABC110101440
      DEF000212532
      GHI100110330
      JKL011300541
      MNO123001016106
      PQR02350010100
      STU51111514410
      VWX123300990
      XYZ411100770
      QTY SOLD ON DATE13101217318735419


      I need below table as a summary. Please help.

       

      Weekly ReportQTY
      TOTAL QTY SOLD73
      TOTAL QTY REORDERED54
      TOTAL QTY NEED TO ORDER19