6 Replies Latest reply on Feb 18, 2016 1:24 PM by siplus

    Matrix data into Table

    Powerbook

      I'm trying to figure out how to convert a table that has matrix datas into a simple table.

      This would be my case:

       

      "user"      "Fruit1"     "Fruit2"     "Fruit3"

      -----------------------------------------------------

      Client1     apple     banana         plum

      Client2     apple

      Client3                   banana          plum

      Client4     apple                           plum

       

      and this is how I would like to convert in the same solution into a new table.

       

      "user"     "fruit"

      ----------------------

      Client1     apple

      Client1     banana

      Client1     plum

      Client2     apple

      Client3     banana

      Client3     plum

      Client4     apple

      Client4     plum

       

      Since I'm still rookie with FMaker I would most appreciate a hint from you experts.