create List from unordered line of data

[Daniel Schaedler]

Hi everybody

I have a table that looks like this:
Product Plant1 Plant2 Plant3 Plant4
Product1 Plant1 Plant1 Plant1
Product2 Plant1 Plant2 Plant1
Product3 Plant2 Plant2 Plant1 Plant2
....

etc.

this table is a result of other tables, so there is no 'real' data in the
cells, but only formulas. This makes it impossible (for me) to sort the
plants.
Now I would like to get a list of all the different plants per product (but
every plant only once). Any ideas how to do this?


Daniel

P.S.
I really apreciated your ideas last time a had a problem, It's great to
solve problems this fast!