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.

Outcomes