Suljettu

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, meaning data entry work, data entry meaning, meaning data entry, 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, excel group column, excel list example

About the Employer:
( 19 reviews ) Athens, United States

Projektin tunnus: #4286199

36 freelanceria on tarjonnut keskimäärin 74 $ tähän työhön

hossionsumon

Hello sir,Experts here do the project 100% accurate.Waiting for reply....

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

consider it done within 1 hour maximum .. thx

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

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)
5.3
pandey2008

plz view pmb.thanx

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

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)
4.8
dangersystem

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)
4.8
abupabuya

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

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

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)
3.7
shabukumar

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

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

More than 10 years experience in Excel and VBA.

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

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

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

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

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

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

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

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)
2.6
benefitworks

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)
2.5
epdailo

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)
2.2
tevuasohe

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)
1.0
garykirsten

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

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

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

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

It's very easy.

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