Excel sheet edits

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

Taidot: tiedonsyöttö, Excel, Microsoft Exchange, MySQL

Näytä lisää: red black data, m format in excel, meaning of data entry work, data entry meaning, meaning of data entry, customer database in excel, ys, hoodies, excel small work, excel model, combine excel, customer database sheet, excel combine rows, excel row column, excel combine data rows, excel column row, database sheet, excel format cell, excel cell format, excel summary results, excel color cell, column row excel, excel combine, read excel file sheet, excel group list

Tietoa työnantajasta:
( 19 arvostelua ) Athens, United States

Projektin tunnus: #4286199

36 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello sir,Experts here do the project 100% [url removed, login to view] for reply....

$50 USD 0 päivässä
(111 arvostelua)

consider it done within 1 hour maximum .. thx

$44 USD 0 päivässä
(100 arvostelua)

Such jobs are my daily practice. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!

$50 USD 1 päivässä
(38 arvostelua)

plz view [url removed, login to view]

$50 USD 3 päivässä
(67 arvostelua)

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

$70 USD 10 päivässä
(19 arvostelua)

Dear sir, I am a professional data entry worker & can complete this project with your requirements, please see my private message for details!!

$50 USD 2 päivässä
(42 arvostelua)

//////////////SELL ITEMS////////////////

$100 USD 1 päivässä
(8 arvostelua)

Ready to start immediately. IT professional with high expertise in Excel work here. I know many formulas and techniques to do this work quickly. I have seen your file and i assure you that i can do this job 100% perfec Lisää

$42 USD 1 päivässä
(16 arvostelua)

Have few clarifications. Please do not miss to read the messages in your inbox.

$100 USD 5 päivässä
(12 arvostelua)

More than 10 years experience in Excel and VBA.

$45 USD 2 päivässä
(6 arvostelua)

Hi I would like to apply for the job posted by you. RgdS Rohit

$50 USD 7 päivässä
(5 arvostelua)

Hello sir I can do this project, Kindly check your Inbox for my resume. Thanks

$32 USD 4 päivässä
(7 arvostelua)

Hi, I saw your project & file. Ready to go ahead. KR,

$49 USD 3 päivässä
(5 arvostelua)

Expert in developing spreadsheet simulations for planning and analysis. I posses meticulous attention to accuracy and time management. Pls Check PM.

$55 USD 2 päivässä
(3 arvostelua)

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

$60 USD 2 päivässä
(3 arvostelua)

I can help you with this project. I specialize in creating macros for custom cases like yours.

$30 USD 14 päivässä
(2 arvostelua)

Hello, please tell me how many products are there? I'm ready to start and my quote of time and price is for 500 products. All the best! Matei Laurentiu

$50 USD 2 päivässä
(1 arvostelu)

Hope to present a smile on your face on Project Completion. Quality assured.

$50 USD 2 päivässä
(1 arvostelu)

Quality, Accuracy and time, More than ready to do this. Plz check your pm

$30 USD 0 päivässä
(0 arvostelua)

It's very easy.

$30 USD 0 päivässä
(0 arvostelua)