Fix product description spreadsheet

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno 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.

Zadávání dat Zpracování dat Excel Excel Macros

Identifikační číslo projektu: #17117494

O projektu

16 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

sloker18

I am proficient with excel macro/VBA development, I have read through your specification carefully, I believe I can deliver the macro to do the filling of the new text as specified in your project, I am available to st Další

£100 GBP za 1 den
(111 recenzí)
6.4

16 Freelnceři na tento projekt zveřejňují nabídky v průměru £142

FINGERRPRINT

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

£233 GBP za 3 dní
(346 Recenzí)
8.2
Khurramz

Hi So you need a VBA program to automate this whole process. Right? Could you please send me the file?

£100 GBP za 3 dní
(399 Recenzí)
7.6
seoguru17

okay, I have gone through with the requirements and I am good at excel too, I can help you in fixing all issues

£150 GBP za 3 dní
(100 Recenzí)
6.4
Nidhijain123

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ší

£250 GBP za 3 dní
(123 Recenzí)
6.4
konanhenry1111

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ší

£277 GBP za 10 dní
(31 Recenzí)
5.1
rakshitdadhich

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ší

£150 GBP za 3 dní
(23 Recenzí)
5.0
TypingNOW

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!

£166 GBP za 3 dní
(17 Recenzí)
4.6
prasannjeetp

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ší

£95 GBP za 2 dní
(46 Recenzí)
4.5
marloufin

Hi, I've been working with excel vba for 3 years and currently creating company tools for users reporting. I will be able to help you with your requirements. We will create macro to consolidate or merge the 3 colu Další

£111 GBP za 3 dní
(7 Recenzí)
4.1
osamasuleman

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ší

£61 GBP za 3 dní
(1 recenze)
0.3
Dextah25

Hello You need not only talent but accuracy as well to work on this spreadsheet. With my skills in using excel, please allow me make impressive changes and touches on your spreadsheet. I hope to create a lasting rela Další

£130 GBP za 3 dní
(0 Recenzí)
0.0
Sparks254

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

£80 GBP za 3 dní
(0 Recenzí)
0.0
Marcel4web

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ší

£80 GBP za 2 dní
(0 Recenzí)
0.0
Jmartha

Hello, I have carefully read your job description and because I've been a Data entry Agent for 5 years, I am confident i can complete your job very well. I have worked for Samasource - an Outsourcing company- for a Další

£133 GBP za 3 dní
(0 Recenzí)
0.0
shoryasehgal03

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ší

£155 GBP za 3 dní
(0 Recenzí)
0.0