Tamamlanmış

Update and correct 2 columns in a spreadsheet

I have exported a spreadsheet of furniture items for sale on our website to send to another company and they require the data to be in a certain format. I have already formatted most of the data as they require, but only 2 columns are left and they are too tedious for me to do right now, so I need your help.

These 2 columns are the item Categories, labeled Category 1 and Category 2.

Currently the Category 1 column is blank and it needs to be filled in with the correct value for each of the items in the sheet.

The possible values for Category 1 are:

Beds, Screens & Other

Case Pieces & Storage

Lighting

Mirrors

Seating

Tables

The Category 2 column currently has all the correct values from our website export, but these values do not necessarily correspond to the possible values the company requires. So each type needs to be examined and updated accordingly.

The possible values for Category 2 to be updated to are numerous, so I won't print them all here. Instead please refer to the attached reference spreadsheet that was provided to me by the company I'm needing to send this data to. If you open up their spreadsheet and go to the "Categories" tab, you'll be able to see all the possible values for Category 2 and how they correspond to the proper values from Category 1.

Probably the easiest way to do this job is to start with filling out all the values for Category 1, using my current Category 2 as a reference guide. Then when the Category 1 column is all filled out, move on to Category 2 and compare each value to the possible values for Category 2 in the company's reference spreadsheet and correct each one of them using Find/Replace. However, please note this would only work if you can use Find/Replace on values in the Category 2 column ONLY - doing a Find/Replace text on the entire sheet will ruin other parts of the data.

Also, I made a screen capture video that explains this more here:

[login to view URL]

Finally, when you are done, I need this back in my original XLSX spreadsheet, as well as a plain CSV file.

Please let me know if you have any questions. This project was a bit difficult for me to explain this late at night :)

Thank you,

Greg

Beceriler: Excel, Veri Girişi, Veri İşleme

Daha fazlasını gör: bash script read columns spreadsheet, correct name excel spreadsheet, update sql server excel spreadsheet, update sql database excel spreadsheet, correct spelling mistakes spreadsheet, write some articles - $2 per 500 words start immediately, write some articles 2 per 500 words start immediately, change update correct your wrong aadhaar data entry, freelancer update 1.2, can i start doing bookkeeping from home, how to start doing freelance graphic design, how to start doing outsourcing programming job in uplink, update oscommerce 2.2 to 2.3.1, want to start doing translations, i need 2-3 data entry experts for some excel work and long term work. you will be doing lots of typing. there are mostly studen, script is done but the main functionality is not implemented well you so we have to make it correct -- 2, update joomla 2.5 , update correct code, woocommerce 2 columns mobile, how do i start 2 columns in the middle of a word document?

İşveren Hakkında:
( 64 değerlendirme ) Plato, United States

Proje NO: #29399016

Seçilen:

techdesigno

Hello i can deliver this project in the same day. i have lots of experience with excel spreadsheets and i am the right person for the job. let's get this job done. hire me and i'll make sure you have everything ready w Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(0 Değerlendirme)
0.0

Bu iş için 27 freelancer ortalamada $21 teklif veriyor

saminatinny

hello, i did already similar work..i can start the work immediately once u awarding me .kindly chat with me we can discuss details and better understanding of your vision .i will provide u 100% correct work .thanks

$20 USD in 2 gün içinde
(44 Değerlendirme)
5.2
chetandc

Hey there, I see you’re looking for someone for Update and correct 2 columns in a spreadsheet I have years of experience in Data Processing, Data Entry and Excel, etc. I can also edit product images if required and I Daha Fazla

$20 USD in 2 gün içinde
(28 Değerlendirme)
4.7
designer504

Hello, I am ready to start right now. I can professionally work on your project according to your requirements. I am an expert in DATA ENTRY, CSV Editing, PDF, Digitization, WORD, Scan to Text with 10 years experienc Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
4.8
kchoudhary95

please give me the opportunity to do your job. I will do my best effort. . I cam move that . . . . Greetings! My name is Kamlesh Kumar and I am a full-stack web developer. I believe my skills match your project. I have Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
3.1
abmcoders

Do you need a reliable and professional Virtual Assistant for Data Entry, Web Research, Typing Work, Copy Paste and Excel Data Entry, Any Administrative related works? Yes, you are in the right place. Data Entry Web Re Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
2.6
navneetpatyal

Dear Client, I will do this work. Message me when to start the work? I Will provide Quality, Speed, and Accuracy at the Lowest Price. Regards Navneet.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)
2.4
sanjunalin7080

I read your requirement. I have good experience in Data Entry, Excel, Internet Research, Research, Web Search, Lead Generation, email listing , Data Mining Project Emails, database - information from excel sheet. I wou Daha Fazla

$10 USD in 7 gün içinde
(0 Değerlendirme)
0.0
antoniamilcheva2

Hello, My name is Antoniya. My Top Skills word, Excel, Microsoft Office,Internet Research. I have 15 years experience. Develop high-quality marketing and communications materials (mostly articles) showcasing B EYE‘s so Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
rohitdhumale56

I m very addictive with excel work and I will give u a best work done and satisfaction I have experience this type of work give a chance help you

$30 USD in 5 gün içinde
(0 Değerlendirme)
0.0
Semenchuk22

Hello. I can do this job with high quality, during minimal time period, and low price. I am ready to start this project imediately.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
jiansevillejo

Hi, I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I have watched the video and I'm willing to discuss more about the project.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.0
kapil2526

Hello Greg How are you doing? Would love to help you in your business. We assure you that your work would be delivered in the give time frame. Best Wishes!

$20 USD in 2 gün içinde
(0 Değerlendirme)
0.0
itzumeshv

I am a professional and speedy who can assure you the high quality and accuracy of your project. Professionally, I have worked on many projects with successful and satisfied completion. You will find me the right optio Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
gujjardharma

I can complete the given task on time. I have completed my projects to edit, corrections in data entry & transcription.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Muzammil117

hello sr/madam do you need a freelancer to work for you here we are we read your requirements and found us eligible please give us order to serve you with our skills

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
zibonahmmed101

Hello I am a data entry operator. I know about your work very well. I am expert in excel. I have confident that i will do your work very well. Link to my previous work [login to view URL] I hope you would like to Daha Fazla

$10 USD in 7 gün içinde
(0 Değerlendirme)
0.0
ed1881

Having an administrative background, and an analytical leaning, I would be more than happy to assist. Please let me know if you require any further information?

$36 USD in 3 gün içinde
(0 Değerlendirme)
0.0
Dmstech77

Hi bro i read it completely and i understand it all. I do it with accuracy. I have dynamic skills and much more knowledge about it... I will provide you a quality work

$20 USD in 2 gün içinde
(0 Değerlendirme)
0.0
CloverLeaf18

You bump into the right person! Let's me help you lessen your burden in hiring. I am made for this job. HIRE ME NOW! I can do this work for you and deliver before it due time. Thanks. Rachelle A.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
patnimowais

Hello there, I have read your project details. I'll make sure you that my team is well qualified and experienced for this project. We are strongly experienced in Word | Excel | pdf. We have also seen your attached file Daha Fazla

$10 USD in 2 gün içinde
(0 Değerlendirme)
0.0