Need some help with the logic & methods...

[iPixel]

Ok so i got an excell spreadsheet that contains data like so ...

 

Part No.    Vendor      Color    Width    Height    Depth              <-- This is the header of the xls. spreadsheet

12345        ABC        RED      24"        40"          24"

23456        ABC        BLUE    11"        22"        11"

33461        ABC        Green    12"        55"        21"

 

 

etc....

 

Whats the best way to read through this spreadsheet, and then reshuffle the info to look like this ...

and place it back into a new spreadsheet

 

12345    ABC    COLOR    RED

12345    ABC    WIDTH    24"

12345    ABC    HEIGH      40"

12345    ABC    DEPTH      24"

 

23456    ABC    COLOR    RED

23456    ABC    WIDTH    11"

23456    ABC    HEIGH      22"

23456    ABC    DEPTH      11"

 

etc....

 

Should i somehow do a multidimentional array ..

12345 => (Vendor => ABC) (Color => RED) (WIDTH=>24") etc ...

i think more or less that what that would look like ..

 

or does anyone have a better method of doing this ...