Address Column Standardization - repost

Closed Posted Feb 11, 2014 Paid on delivery
Closed Paid on delivery

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.

Data Entry Data Processing Excel

Project ID: #5424907

About the project

22 proposals Remote project Active Mar 21, 2014

22 freelancers are bidding on average $24 for this job

hossionsumon

Dear sir, Greeting, I'm so interested in your project. Already my team finished many similar projects. I've extensive experience team to do the jobs very fast accurate. The work will be absolutely perfect and sound w More

$33 USD in 1 day
(185 Reviews)
6.9
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 More

$23 USD in 1 day
(106 Reviews)
6.6
deepbluetech

Hi Anupama Sudheer, I specialize in Excel based projects and shall complete the tasks within a day. Please confirm and provide relevant files. Regards, Arul

$30 USD in 1 day
(105 Reviews)
5.8
rinsadsl

Dear Anupama I can standardize the address column for you. Looking forward to work on this project. Thanks Rinsad

$23 USD in 2 days
(18 Reviews)
4.4
dforce101

Hi, I am highly qualified for such task and very eager to start the job I am confident that I have understood the job very well and can do it perfectly according to your requirement after going through the Project d More

$24 USD in 2 days
(1 Review)
3.4
nswapsj

Hi there. Conciser it done. I will design it for you in such way that you will get a dynamic file, meaning you can use it as your data changes, for any future data, and will not need to pay for such service again. Drop More

$30 USD in 1 day
(1 Review)
2.1
livewireinfo88

We have +3 years experience in data processing. and having a 15+ skilled people to work on the different projects. we can discuss this project to get the satisfactory work form us.

$25 USD in 1 day
(0 Reviews)
0.0
singhbishtamit

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
rajiv77

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
sampransh

I have good excel and macro skills. I have earlier handled similar task for 4000 line in one excel sheet. and rearranging in different format with logical combination. I will be able to work fast and efficient on this More

$23 USD in 2 days
(0 Reviews)
0.0
abhii226

A proposal has not yet been provided

$22 USD in 1 day
(0 Reviews)
0.0
fernando4relax

I will do it good. I've done these works. I can cooperate with you more after this project if you want.

$20 USD in 2 days
(0 Reviews)
0.0
irenenov

Hai... I'm interesting with your project and I think I'm suitable to do this project. I usual work with a lot of data spreadsheet in my old company and familiar enough with many records and data. Please contact me a More

$15 USD in 1 day
(0 Reviews)
0.0
lefleon1973

Δεν έχει γίνει καμιά πρόταση ακόμα

$16 USD in 4 days
(0 Reviews)
0.0
khurram2096

To work with excel is my routine and i am using excel for last 20 years. i think its not a big deal to fulfill this job requirement.

$20 USD in 1 day
(0 Reviews)
0.0
thilanka85

Hellow I'll complete this work successfully with out any error. waiting for a favorable reply Thank you, Thilanka

$15 USD in 1 day
(0 Reviews)
0.0
jninopena

I will provide you with a Excel or CSV file with the information you request. I will be using java to perform this activities. I have done similar things in the past involving ETL.

$30 USD in 2 days
(0 Reviews)
0.0
Pietrofarias

Hello. I would love to talk about your project. Develop work with organizational analysis, which develop projects and spreadsheets always seeking the best ways to view and way of working. I believe we can understand ou More

$30 USD in 3 days
(0 Reviews)
0.0
AmudhavaniS

I understood the requirements of the project. I have worked in one of the top most IT company as a software Engineer . I assure that I will complete the task on time.

$30 USD in 1 day
(0 Reviews)
0.0
peliwaft

i'm interested in doing this project. i hope i can do this project well and good. i can do it accurately.

$30 USD in 1 day
(0 Reviews)
0.0