Completed

Data entry or simple data entry script (Visual Basic, VBA or something like that)

I have an excel file with three columns. The first column is the identifier. The second column lists the group that the identifier belongs to. In col C, I need you to to enter all the values in column 1 that is part of the group, separated by a comma. For example:

I give you this:

Col 1 Col 2

one b

two b

three b

four d

five d

six e

You return this to me:

Col 1 Col 2 Col 3

one b one,two,three

two b one,two,three

three b one,two,three

four d four,five

five d four,five

six e six

There are 6000 rows. Most of the groups contain 3 to 6 items (identifiers).

This can be done by hand, or if you know how, you probably write a simple script to do this.

Thank you.

Skills: Excel, Visual Basic, Data Processing, Visual Basic for Apps, Data Entry

See more: excel vba userform code examples, excel userforms for data entry pdf, data entry userform in excel free download, excel data entry form vba code, excel vba data entry form template download, excel userform data entry template, excel userform add data to table, how to capture data from userform into excel worksheet, ftp script visual basic, merging textfiles visual basic vba, login script visual basic database, excel top ten macro script visual basic, insert data sql server using visual basic net, simple pricing sheet visual basic, simple loan calculator visual basic, simple image rotate visual basic, simple attendance system visual basic net, windows 2003 logon script visual basic, script visual basic excel 2007 sample, simple web chat visual basic

About the Employer:
( 50 reviews ) Montreal, Canada

Project ID: #24482460

Awarded to:

pranjalk2902

Hi, I'm Pranjal from Mumbai, India! Firstly I would like to tell you that I have the requisite VBA program to achieve this automation over 6000 rows or even more fully ready to be submitted for your perusal. If you c More

$30 USD in 1 day
(28 Reviews)
4.3

81 freelancers are bidding on average $39 for this job

elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I can write a script to do the task just by pressing a bu More

$50 USD in 1 day
(250 Reviews)
7.0
sumon355

Hello, As an experienced VBA developer, i am very much interested to do this work by script. But i need some clarification. Looking forward to have a positive response from you. Thanks

$50 USD in 2 days
(170 Reviews)
7.1
(179 Reviews)
7.1
ineedWorkJob

Greetings sir, I have read your project details and i will work on your 600 rows of data and provide you the data in few hours. Sir, i can deliver this project sooner than you expect and will be over your satisfa More

$50 USD in 1 day
(143 Reviews)
6.5
VladimirLilenko

Hello! I'll do it for $ 30 and a few hours You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Excel, of course, familiar. Regards, Vladimir

$30 USD in 1 day
(140 Reviews)
6.5
finecodervw

Hi, Keen to work on this. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It include More

$30 USD in 1 day
(103 Reviews)
6.0
rashedkhanrubel

Hi, I will make Visual Basic code to organize data as per your requirement with good and professional quality without any error. I have completed more then 100 project within 8 months with 5 star review. You are gentle More

$45 USD in 2 days
(138 Reviews)
5.9
mtdevil369

Hi, how are you ?? please check my profiles?? I have understand the project requirement & interested to work for this project. I will start right now and I will do it before your time . Please send a message so we can More

$50 USD in 1 day
(190 Reviews)
6.3
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Not be done by hand - I'll More

$50 USD in 2 days
(33 Reviews)
5.7
saqibraza2262

hi, can do manually(1 by 1),if you can give 3 days to me,with accuracy. waiting yours response on chat. Regards.

$60 USD in 3 days
(21 Reviews)
4.6
MartinDudumi

I'd like to be considered for your request. I am a data guy with a strong background developing several access tools including vba automation and complex queries and I can assure quality and accuracy in a short time ba More

$50 USD in 1 day
(21 Reviews)
4.6
IgeS

Hi there, Need to stack the data from column b into column c if Column a match automatically using a Macro? Please message me if this is any of what you need. I’ll be standing by to help. Reggie

$50 USD in 1 day
(19 Reviews)
4.7
gsanggara

Hello There, I am very interested to your project. I am full-time advance excel freelancer, available & ready to work on your project right now. I can create data entry script to enter data in column C as per your form More

$30 USD in 1 day
(28 Reviews)
4.1
webanis

Hello! I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am su More

$40 USD in 1 day
(26 Reviews)
4.2
capatel341

Hi, I am expert in Microsoft Excel, Word, PowerPoint, Data Entry and Web Research Work. I will do Excel Work accurately, timely and within your budget. Let me know if you have any questions. Thanks & Regards, Chira More

$30 USD in 1 day
(47 Reviews)
4.1
zaahidali61

Hi next Employer, I have read your project and interested in it. I hold master degree in Business Administration (Finance). Having more than 10 years of experience of data entry Microsoft office, Web Scrapping, Intern More

$30 USD in 1 day
(16 Reviews)
4.1
emilianoreyes70

Hi! Im ready to start!. I am a entrepenour and Excel/VBA/Macro ans Google Scrpit , Google Sheets expert. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including More

$40 USD in 7 days
(6 Reviews)
3.4
ITZ001

Greetings, Hope all is well with you!!! Many thanks for sharing your requirements on Freelancer. I just read your posting. It sounds like you need a freelancer who is having an expertise in Data Entry for doing this More

$40 USD in 7 days
(4 Reviews)
3.3
claudiaprey

Tengo disponible horario diurno y nocturnos con más de 20 años de experiencia como Ingeniero en Sistemas; especialista en programación y en informes de cualquier indole. Manjeadores de Bases de Datos (SQL, MySql y Orac More

$40 USD in 2 days
(1 Review)
3.4
Monirulop

Hi there, After carefully reviewing the requirements of the job description, I feel that I am a suitable match for the job. I am ready to start right now & deliver in a few hours or less. I would be glad to assist yo More

$30 USD in 7 days
(10 Reviews)
3.4