Excel sheet edits

Closed

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

Skills: Article Submission, Articles, Copy Typing, Data Entry, Ghostwriting

See more: 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

Project ID: #4297030

15 freelancers are bidding on average $423 for this job

kulhanekd

I have 15 years exp in excel. I can create the sheet you need. Donna

$250 USD in 2 days
(5 Reviews)
3.8
jal540

I am very experienced with Excel and have excellent ratings.

$300 USD in 14 days
(5 Reviews)
3.4
danielbarragan13

I've got the skills needed to complete your project ASAP. PM for details

$250 USD in 2 days
(0 Reviews)
0.0
Dasker

Dear Sir / Madam, Please see your PM...

$300 USD in 5 days
(0 Reviews)
0.0
mihaelapanoiu

Good day i'm rather new but would love the opportunity to complete this project, all i need is a chance. Hope to hear from you soon Thank u and have a great day

$600 USD in 15 days
(0 Reviews)
0.0
Hafizkhan

Dear Hiring Manager, In response to your recent advertisement on web I am offering myself for the same. I have 7 years working experience of MS word and MS excel collecting, processing work. So, I think I am appropr More

$300 USD in 15 days
(0 Reviews)
0.0
nemanjarobija

Hello Sir, i'm interested in your ptoject please check PM.

$250 USD in 10 days
(0 Reviews)
0.0
Teletec

Dear Client, After reviewing your requirements, we have clear idea about the project. We believe that we are best suits to provide you with the outcome that you are looking for. With our more than 2 years experien More

$250 USD in 7 days
(0 Reviews)
0.0
Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert =============== More

$250 USD in 2 days
(0 Reviews)
0.0
hafizur22

please give me your work

$250 USD in 10 days
(0 Reviews)
0.0
bidstrup2000

Hi, I can do this.

$300 USD in 14 days
(0 Reviews)
0.0
stephenelliott

I need the excel file in the PMI (or public post). Also, let us figure out the milestones. To get started, would be the first milestone (covering the time to evaluate the excel file and the instructions and get all q More

$2000 USD in 360 days
(0 Reviews)
0.0
enghamoosh

hello, I understand what you need , I'm perfect in doing excel stuff and databases and If you'd like ill do it to be SQL database to use it more easily on your website regards

$540 USD in 6 days
(0 Reviews)
0.0
sandhyashammi

I had more than 6 years experience in data entry field. Before I'm working data entry operator in HP (HEWLETT PACKARD) MNC company . & also I had Worked as DATA ENTRY OPERATOR IN BPO field in SMART TECHNOLOGIES PVT LT More

$250 USD in 10 days
(0 Reviews)
0.0
shawnqurash

HI Khan saheb. I am a fresh Freelancer from Pakistan. Your Job seems interesting to me and I am ready to do this job. Have a look at my profile and let me have the opportunity to do this for you. Thanks and regards.

$250 USD in 7 days
(1 Review)
0.0