Creating Product hierarchy from a Flat structure table.

[alkesh_sharma]

Hello,

I have a table with product codes, and based on the product codes I need to create product hierarchy:

The codes are as below:

     Level 1: 10100 – Enamel

           Level 2: 1010001010 – S H E

                Level 3: 101000101010101010 – Whites

                Level 3: 101000101010101020 – Colors

                Level 3: 101000101010101040 – Tinted Bases

           Level 2: 1010001020 - SuperLac Satin Finish

                Level 3: 101000102010102010 – Whites

                Level 3: 101000102010102020 – Colors

                Level 3: 101000102010102040 - Tinted Bases

and so on.....

All these codes are in the same table and same field but need to be bifurcated  based on the code.

Need need GUYS!!

[fkeuroglian]

External excel with the hirechachy?