Here is the work we needed done to our new database of products we have in an excel format.
Combine each product style color into one row. Meaning, there is a row for each color and a row for each size of that color. We need those to be combined into one row so Product A in white with rows for small, medium, large would be combined into one row.
When you combine the rows for each color, we want a summary of the sizes you combined. Each row for that color had a size listed, we need a column created with those sizes being separated by a comma. So if you look at the example file, a cell for the product model# 16130 in True Red, C62047 would list the sizes: 3XL,2XL,XL,L,M,S
We then want a summary of the sizes from the smallest size that is offered to the highest letting a customer know that product is available in in sizes YS-4XL for example in that True Red color. NOTE: each product will be available in different sizes and colors. Meaning just because the True Red is offered in YS-4XL does NOT mean the same product in Black is offered in those sizes. We need a column with these results.
Combine the Color Group column and the Hex color column so there will be one column for “colors” that would read like True Red, C62047 Currently, there is one column for “True Red” and another column for “C62047” we want those combined and have a comma between the two.
We will provide names the columns
FrontImage BackImage LeftSideImage RightSideImage
For each subcategory. You would need to apply the names given as seen in columns P-S
The last thing that would need to be done is separating each product with a row called #NewProduct. This tells the database when a new product starts and ends
We will need a final file for each Subcategory named in that title. So Sweats would have 3-4 subcategoires like Hoodies for example and the final files would have 1 file with just the products from the Hoodies subcategory named Hoodies
36 freelancers are bidding on average $74 for this job
hi, i can do it. I'm programmer for year and very familiar with VBA for excel automation. I can give you the macro enable excel file so you can also run it whenever you need in future. Best regards, Cuong NH
Hi Sir, Completely understood your requirement. I will get you what you want in 2 days. For more confidence on me you may like to check my reviews. Thanks Karim