Fix product description spreadsheet

Tamamlanmış İlan edilme: 5 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

*****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.

Veri Girişi Veri İşleme Excel Excel Macros

Proje NO: #17117494

Proje hakkında

16 teklif Uzak proje Aktif 5 yıl önce

Seçilen:

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(111 Değerlendirme)
6.4

Bu iş için 16 freelancer ortalamada £142 teklif veriyor

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 in 3 gün içinde
(346 Değerlendirme)
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 in 3 gün içinde
(399 Değerlendirme)
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 in 3 gün içinde
(100 Değerlendirme)
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 Daha Fazla

£250 GBP in 3 gün içinde
(123 Değerlendirme)
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. Daha Fazla

£277 GBP in 10 gün içinde
(31 Değerlendirme)
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 Daha Fazla

£150 GBP in 3 gün içinde
(23 Değerlendirme)
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 in 3 gün içinde
(17 Değerlendirme)
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 Daha Fazla

£95 GBP in 2 gün içinde
(46 Değerlendirme)
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 Daha Fazla

£111 GBP in 3 gün içinde
(7 Değerlendirme)
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 Daha Fazla

£61 GBP in 3 gün içinde
(1 Yorum)
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 Daha Fazla

£130 GBP in 3 gün içinde
(0 Değerlendirme)
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 in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

£80 GBP in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

£133 GBP in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

£155 GBP in 3 gün içinde
(0 Değerlendirme)
0.0