Excel->Visio : Automation of a complex mapping

[prasadtsn]

Hi Xperts,

I have an excel workbook with the following:
1) Sheet-1 : List of all unique items
2) Sheet-2 : List of all mappings (many to many) between the items (from sheet-1)
[The mapping between two items is unique however]

Example:

Sheet-1:
Table
Chair
Purse
Phone
Pen

Sheet-2:
Table Chair
Table Purse
Chair Purse
Chair Phone
Chair Pen
Purse Table
...

The value on the left in sheet-2 is a child of the value in the right of sheet-2

Any way to automatically create a chart using macro/wizard etc... ?

I tried the org chart wizard but stuck with the prob that it does not allow two parents - one child relationship.

Please help urgently.

Prasad