[AccessD] Normalization Cleanup Problem

Group,

I have inherited a poorly designed table which I now have the time to fix.
It is the classic list of items and numerous fields for each category to
which each item applies.  I've already created and populated the normalized
tables.  What is the easiest way to make a junction table out of a table
created in this manner?  Thanks for any suggestions.


Example Record (not real data):
ID         1
ITEM       Apple
FRUIT      X
VEGETABLE
RED        X
YELLOW     X
GREEN      X
PURPLE
VINE
PLANT
BUSH
TREE       X


Mark