Address Column Standardization

In Bearbeitung Veröffentlicht Feb 11, 2014 Bezahlt bei Lieferung
In Bearbeitung Bezahlt bei Lieferung

I have 2 tab delimited files (sample attached) 1 Customer list with about 4000 records & 1 Vendor List with about 1300 records, each with a billing address & shipping address. 5 lines/columns/address.

I need:

Address 1 = Customer Name

Address 2 = If there is an appropriate value, use it. Could be ATTN: John Smith, Accounts Payable, etc. If nothing is there,

"Accounts Payable" for Customer Billing

"Receiving Department" for Customer Shipping

"Accounts Receivable"for Vendor Billing

"Receiving Department" for Vendor Billing

Address 3 - Primary Address (1 Main Street)

Address 4 - City, State Zip

Address 5 - Country (if applicable, Blank for US is fine)

If the shipping address is blank, the billing address is fine.

Hi all, no clue why the files aren't uploading. Frustration.

Sample file is here: http://www.arnoldgauge.com/other/vfreelancer/

Datenerfassung Datenverarbeitung Excel

Projekt-ID: #5424878

Über das Projekt

34 Vorschläge Remote Projekt Aktiv Feb 13, 2014

Vergeben an:

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that I can start with the implementation.

$30 USD in 0 Tagen
(160 Bewertungen)
6.6

34 Freelancer bieten im Durchschnitt $28 für diesen Job

diamond247

Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job, i have gone through your project description, its really a Mehr

$30 USD in 1 Tag
(103 Bewertungen)
6.6
binaryromel

Hi there, I'm exert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me your sample. Thank you, FARZANA PINKY.

$27 USD in 0 Tagen
(69 Bewertungen)
5.7
skgtechnologies

Dear Client, I have gone through the project description and I would like to offer my services for the same. I work as full time freelancer and have 10 years of experience in this field. I can reliably work on dail Mehr

$30 USD in 1 Tag
(19 Bewertungen)
5.1
tusharozone

Hello, I have read description carefully. We can start the work immediately. If you have any queries related to deadline of work or any other queries please let us know. Looking for healthy and long term business rel Mehr

$30 USD in 2 Tagen
(43 Bewertungen)
4.8
caabdul

Greatings! I am a bit busy but can do the job after 3 days, thank you

$20 USD in 4 Tagen
(16 Bewertungen)
4.1
permana22sl

Dear, I'm serious person, I can do the task accurately and perfectly. I understood this project's requirements exactly. I am representing my bid as a core interest and available to further discussion. I am waiting for Mehr

$25 USD in 1 Tag
(14 Bewertungen)
3.4
d2imatrix

Hi, We had looked into the sample. Here's what we have understood and also there are few clarifications we would like to make. 1. Name column shows names like 'Accubar Inc.', Atlas Crankshaft Corp. etc. 2. In your d Mehr

$20 USD in 1 Tag
(1 Bewertung)
3.2
BDtW

Hi, I have gone through the tab delimited file (opened it with excel) and saw the structure of the table. What I find from your description is that mainly I'll have to work on only 2 * 2 = 4 columns per record. Colu Mehr

$32 USD in 2 Tagen
(6 Bewertungen)
3.2
arman0464

!!Hello Sir/Madam, Ready to start. I read your description carefully and understand all your requirements. I have 6 years experience in this field. Please open message board for further details. Regards Shareef

$30 USD in 1 Tag
(13 Bewertungen)
3.2
sathyasingh1991

* OM SAI RAM * Respected Sir/Mam, I have read the project completely and I have understood my responsibilities (If awarded) clearly. To tell more about myself, I am dedicated and sincere in working on the pro Mehr

$25 USD in 7 Tagen
(8 Bewertungen)
2.5
nazwie77

well i can do it ! in fact i am ready to start working as soon as possible! so let me know , On the other hand i am very experienced on line marketing , also I am highly skilled in the use of computers and the Internet Mehr

$30 USD in 1 Tag
(0 Bewertungen)
0.0
lianaliza85

i want to do this project. i have my skill on excel. i can make up to you. but there no attach file as you said here.

$111 USD in 5 Tagen
(0 Bewertungen)
0.0
Noushin24H7D

Good day! After reading the project description, i am confident that i can do this job. I hope you will consider me for this job and i can start immediately. Noushin

$123 USD in 3 Tagen
(0 Bewertungen)
0.0
dipak31791

I have group of people who are quite fst in this kind of work. It will be done with in 1 day.. Waiting for your response Regards ...

$25 USD in 1 Tag
(0 Bewertungen)
0.0
jen20074u

A proposal has not yet been provided

$25 USD in 1 Tag
(0 Bewertungen)
0.0
tareg

A proposal has not yet been provided

$25 USD in 1 Tag
(0 Bewertungen)
0.0
mechandaneck

Hello Sir, I am an engineering graduate with 6+ years of experience for an IT firm involving System Administration works to report & presentation preparation tasks. These tasks including doing research on internet and Mehr

$16 USD in 1 Tag
(0 Bewertungen)
0.0
raoirfan22

A proposal has not yet been provided

$25 USD in 1 Tag
(0 Bewertungen)
0.0
spcddesilva

Dear Hiring Manager, I am writing in response to your advertisement. After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I have good experienc Mehr

$25 USD in 1 Tag
(0 Bewertungen)
0.0
StormDash9

A dynamic and results-driven professional with a highly successful background. Committed to achieving and exceeding demanding targets, while remaining focused on providing an exceptional standard of service. I invit Mehr

$30 USD in 1 Tag
(0 Bewertungen)
0.0