WooCommerce CSV Import Suite Expert Required

We currently have a custom made Wordpress Ecommerce site that we would like to upgrade to use WooCommerce. We are having trouble importing the product data that our supplier provides us with and are in need of some expert knowledge in the CSV Import Suite plugin that we purchased from WooCommerce. The problem we are facing is that the CSV import suite requires each product attribute to be in the same Cell (one product per row) and our CSV from the supplier has each attribute as a seperate line. Please take a look at the attached sample files so you can see what the problem is: Brief example: CSV import suite requires: (1 row) Column Size: S|M|L|XL|2XL Our Supplier Feed: (5 rows) Column Size: S M L XL 2XL Look at attached file: [login to view URL] Also note that it seems there is no possibility for different size, colour combinations.. i.e. in the example note that colour orange only goes up to 2XL however colour Red goes up to 3XL, we would also need a solution for this. This isn't a massive job who someone that has done it before so if you haven't got experience in this type of import or excel!