Create product database from csv files

I have a selection of around 10 csv files which I have uploaded, as you can see from first column the product sku is sometimes duplicated because each product has many options, what I need is this format to be imported into oscommerce so that there is only 1 product but with the different size and colour options loaded for each with the stock sku code so we know what to order in or send out, I have the website already setup with each option as a seperate product and this is very confusing to the customer and also annoying via admin, If you look at [login to view URL];id=7103 is another competitor of mine and I like the way they have laid out product_info page, mine is similar, but need all the sizes, colours, pictures etc. For more information, please pm me and I will give your more details