data entry for amazon store from ebay spreadsheet and store - repost

I am looking to add my products from Ebay into Amazon. I have two spreadsheets, one containing my active ebay auctions ([login to view URL]) and a blank one that amazon requires to be populated [login to view URL] I need someone to add one line for each size and one line for each colour offered. so if 1 t shirt on ebay has four sizes on the auction, and those four sizes have ten colours each, it will need forty rows for those t-shirts 1 line per style, per size, per colour. The columns should be populated as follows on [login to view URL] (please note i have hidden columns i do not need, please do not delete them tho). D - peoduct id type - this is always 4 E - price - this comes from the ebay spreadsheet for each line H - item-condition - this is always 11 J - add - delete this is always a K - will ship internationally always 6 O - manufacturer name - RamGFX always T - size - this comes from Ebay auction from the item id (one line per size) U - colour this comes from Ebay auction from the item id (one line per colour) V - product type - this comes from category leaf name on ebay spreadsheet X - department - this comes from the item title on ebay spreadsheet needs to be manually entered from - kids, mens, womens, bag, hat etc. Y - Product name - item title from ebay spreadsheet Z - Product description - from ebay auction search on item number - only needs item description, not other text.