AnsweredAssumed Answered

Data transformation

Question asked by SteveWu on Feb 13, 2013
Latest reply on Feb 14, 2013 by SteveWu

Title

Data transformation

Post

     I am new to FMP and I need to reassign data points from one master table to two separate tables. The master table looks like this --

     ID      Value1      Value2      Week

     101      21             51              1

     102      22             50              1     

     103      21             52              1     

     101      20             49              2

     102      19             53              2

     101      23             48              3

      

     I would like to reassign the numbers to two tables like these --

     Vaule1 table:

     ID        Week_1        Week_2        Week_3    

     101        21                  20                 23

     102        22                  19

     103        21

      

     Value2 table:

     ID        Week_1        Week_2        Week_3    

     101        51                  49                 48

     102        50                  53

     103        48

      

     I will appreciate any generous input on this matter. Thanks in advance!

      

      

Outcomes