Project Detail

Edit XL CSV File - Merge 2 fields and grooup User IDs

Edit XL CSV File - Merge 2 fields and grooup User IDs is project number 485208
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: SouthIndian

Budget: $30-250

Created: 08/08/2009 at 23:10 EDT

Bid Count: 5

Average Bid:
$ 30

08/09/2009 at 23:10 EDT

Project Creator: rcvanderplaat offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (32 reviews)

Description

I have a XL document and need 2 things done to it

1) Merge 2 fields "address1" and "address2" into 1 field called "address"

2) Merge Duplicated contacts IDs into 1 contact ID with comma seporated Cat_ID, See below

ID link_name cat_id

13 BSI People 1420
13 BSI People 1354
13 BSI People 1355
13 BSI People 1412
13 BSI People 1271
15 Courtenell Pty Ltd 1403
15 Courtenell Pty Ltd 1482
15 Courtenell Pty Ltd 1383
15 Courtenell Pty Ltd 1350
15 Courtenell Pty Ltd 1338
15 Courtenell Pty Ltd 1496
15 Courtenell Pty Ltd 1441

Should become

ID link_name cat_id

13 BSI People 1420,1354,1355,1412,1271
15 Courtenell Pty Ltd 1403,1403,1383,1350,1496,1441

there are 16384 records so you cant do it manualy

the first 500 records are attached to ths job so you can see the layout, winning bidder will be sent the XL file with all 16384 records.

I need this done urgently and it should be a quick job if you can automate it.

Additional information submitted:

08/08/2009 at 23:14 EDT:
Above took out the tabs here it is again

ID link_name cat_id

13 BSI People 1420
13 BSI People 1354
13 BSI People 1355
13 BSI People 1412
13 BSI People 1271
15 Courtenell Pty Ltd 1403
15 Courtenell Pty Ltd 1482
15 Courtenell Pty Ltd 1383
15 Courtenell Pty Ltd 1350
15 Courtenell Pty Ltd 1338
15 Courtenell Pty Ltd 1496
15 Courtenell Pty Ltd 1441

Should become

ID link_name cat_id

13 BSI People 1420,1354,1355,1412,1271
15 Courtenell Pty Ltd 1403,1403,1383,1350,1496,1441

Additional files submitted:
Sample first 500 Client to Categries Migrate.xls

Report Violation

Job Type

See more: amp, automate, bsi, cat id, comma, contact, contacts, csv, csv file, edit, file, job, pty ltd, quick, quot, xl

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

08-08-2009 23:26 EDT

9.9113/10
(282 reviews)

i can do that for you. no problem.

yousefla offline

0 days

08-09-2009 00:14 EDT

9.881/10
(84 reviews)

Can be done pretty quickly. Choose me and let's get started!

SouthIndian offline

0 days

08-08-2009 23:20 EDT

9.9286/10
(70 reviews)

Please check PMB. Thanks.

gangabass offline

0 days

08-08-2009 23:50 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(50 reviews)

I can do this job for you. See PM for details.

angan offline

0 days

08-09-2009 00:41 EDT

(No Feedback Yet)

This task 100% completed. please check PM

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.