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

    Matrix data into Table


      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.