AnsweredAssumed Answered

Matrix data into Table

Question asked by Powerbook on Feb 18, 2016
Latest reply on Feb 18, 2016 by siplus

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.