search for: colour2

...tom ? ? ? ?green jessie ? ? orange jessie ? ? ?red bill ? ? ? ? ?yellow kate ? ? ? red henry ? ? ?green .. .. I want to find out, in this great dataset, if (the name of) a person is repeated (and which colour are associated).? My output has to be a dataset like this: name ? ? ?colour ? colour2 colour3 ... ... ... jerry ? ? ? ? red pippo ? ? ? ?red tom ? ? ? ? ?red yellow green jessie ? ? orange red bill ? ? ? ? ?yellow kate ? ? ? red henry ? ? ?green How to do? Is it possible to do with Calc? Thanks -- View this message in context: http://r.789695.n4.nabble.com/Ho...