iPixel Posted October 24, 2007 Share Posted October 24, 2007 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 ... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.