Fix product description spreadsheet
£20-250 GBP
K zaplacení v momentě doručení
*****PLEASE READ THE DESCRIPTION*****
--------------------------------------------------------------------------------------------------
I have a product spreadsheet with some scraped data.
I need 1,857 product descriptions condensed into 1 complete and readable description ready for import.
I also need some small changes to be made to the text.
For example
Column 1
Quartz Movement
50 Meters / 165 Feet / 5 ATM Water Resistant
34mm Case Diameter
Mineral Crystal
Column 2
The 34mm gold dial creates a fantastic appearance on this sleek, stylish watch. The brown band helps to bring the look together for something that is sure to catch the eye. The analog display features a high quality quartz movement which is backed by the full manufacturer warranty. This watch is made of stainless steel and leather and is water resistant to 50 meters.
Column 3
Brand Name Emporio Armani
Model number AR0154
Part Number AR0154
Model Year 2012
Item Shape Rectangular
Dial Window Material Type Mineral
Display Type analogue
Clasp Type Buckle
Case Material Stainless steel
Case Diameter 32 millimetres
Case Thickness 10 millimetres
Band Material Leather
Band Length mens-standard
Band Width 20 millimetres
Band Colour Brown
Dial Colour Gold
Special Features Measures seconds
Movement Quartz
Warranty Type Manufacturer and seller combination
Needs to become
Final Description
The 34mm gold dial creates a fantastic appearance on this sleek, stylish watch. The brown band helps to bring the look together for something that is sure to catch the eye. The analog display features a high quality quartz movement which is backed by the full manufacturer warranty. This watch is made of stainless steel and leather and is water resistant to 50 meters.
Quartz Movement
50 Meters / 165 Feet / 5 ATM Water Resistant
34mm Case Diameter
Mineral Crystal
Brand Name: Emporio Armani
Model Number: AR0154
Part Number: AR0154
Model Year: 2012
Item Shape: Rectangular
Dial Window Material Type: Mineral
Display Type: Analogue
Clasp Type: Buckle
Case Material: Stainless Steel
Case Diameter: 32 millimetres
Case Thickness: 10 millimetres
Band Material: Leather
Band Length: mens-standard
Band Width: 20 Millimetres
Band Colour: Brown
Dial Colour: Gold
Special Features: Measures Seconds
Movement: Quartz
Warranty Type: 12 months
--------------------------------------------------------------------------------------------------
Column 1, 2 and 3 have been condensed into 1 column in the order of column 2, 1 and 3.
Please note the insertion of colon's to separate the property and the attribute in column 3. I am sure this can be automated in excel.
Also please note the uniform capitalisation which is applied to the updated final description.
Where present the in column 3 the Warranty Type attribute should be amended to 12 months
This is not an easy task as the spreadsheet is incomplete or some fields information was not found. In this instance the data from the cells should be formatted as best as possible. For example where there is only data from column 3 with 4 headings that will suffice as long as the above changes are made.
I am sure someone with experience with excel can semi-automate this process.
I have completed the first 6 rows of the full description of the excel spreadsheet to illustrate what needs to be done.
Identifikační číslo projektu: #17117494
O projektu
16 Freelnceři na tento projekt zveřejňují nabídky v průměru £142
Hi there, i have gone through the requirement, understood very well. we can get the final column output form the column 1, 2 and 3. Please let us have the file and we can do sample if you wish. Thank you
Hi So you need a VBA program to automate this whole process. Right? Could you please send me the file?
okay, I have gone through with the requirements and I am good at excel too, I can help you in fixing all issues
Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in ge Další
I have read the description. I want to see the examples that you did before. I need to see it to understand well. also I want to make an example to be sure that I can do it as you want. I accept all changes you need. Další
Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of parti Další
Hi, I am an experienced virtual assistant. I can automate this process in Excel. Kindly reply so that I can send you the sample. Looking forward!
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA and all the functions. I can arrange data of your excel template. I will find a logic and use some VBA codes to simplify it and get it Další
Hello I have gone through your project details and read it very carefully, your job can be done with 100% accuracy and in format required by you. Lets chat to discuss it further and get your job done at the earli Další
I believe I am ideal for this job because I possess the exact skills you're looking for, I'm sure I'll deliver remarkable results for your project. Thanks
Greetings, I will restructure the 1,857 product descriptions into 1 complete and readable description for import and also the small changes you require done to the text asap. I believe I make an excellent fit for thi Další
Having done plenty of administrative tasks since almost 4-5 years, I feel that I am the perfect fit for this job. I have a plenty time on hand right now and am highly efficient and work really well under deadlines. Thu Další