Käynnissä

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

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.

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

Taidot: tietojenkäsittely, Excel, Joomla

Näytä lisää: job edit, edit job, csv merge fields, manualy, xl, merge data, Ids, id layout, edit so, data merge, csv merge, joomla fields, become joomla, file csv, processing csv, joomla quick edit, document processing, csv file joomla, csv data processing, contact file csv, need ids, merge csv, joomla can layout, people cant, user fields joomla

Tietoa työnantajasta:
( 314 arvostelua ) Newport, Australia

Projektin tunnus: #485208

Myönnetty käyttäjälle:

SouthIndian

Please check PMB. Thanks.

30 $ USD 0 päivässä
(76 arvostelua)
5.3

5 freelanceria on tarjonnut keskimäärin 30 $ tähän työhön

gangabass

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

30 $ USD 0 päivässä
(65 arvostelua)
5.4
yousefla

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

30 $ USD 0 päivässä
(18 arvostelua)
5.3
eelance

i can do that for you. no problem.

30 $ USD 0 päivässä
(26 arvostelua)
4.6
angan

This task 100% completed. please check PM

30 $ USD 0 päivässä
(3 arvostelua)
2.2