3 Replies Latest reply: Jun 14, 2018 12:21 AM by Nayan Lalla RSS

    Combining independent tables

    Nayan Lalla

      Hi

       

      I have 2 independent tables below.  One is Customer per Month.  The other table is product.  I want to create a new table to show Customer per Month per Product (3rd table below is the result i want). 

       

      How do i do this.  Your help is appreciated.

       

      Kind regards

      Nayan

       

       

      CustomerMonth
      AJan-18
      AFeb-18
      BMar-18
      BJan-18
      CFeb-18
      CMar-18

       

       

       

      Product
      1
      2

      3

       

       

       

      Customer

       

      Month

      Product
      AJan-181
      AFeb-181
      BMar-181
      BJan-181
      CFeb-181
      CMar-181
      AJan-182
      AFeb-182
      BMar-182
      BJan-182
      CFeb-182
      CMar-182
      AJan-183
      AFeb-183
      BMar-183
      BJan-183
      CFeb-183
      CMar-183