Basic data manipulation with formulas or VBA
$10-30 USD
Pagado a la entrega
I have a 2,000 line spreadsheet. Each cell in column B contains one person's name. Column E contains a hyperlink. The hyperlinks are not unique.
I require output so that each line has a unique hyperlink in E. The people's names in column B will go into a column, all in one cell, separated by a '|' character.
For example
Column B == Column E
John Smith == Link1
Tom Green == Link1
Mary Davis == Link2
Susan Johnson == Link2
Bob Moore == Link2
The result after manipulating the data would be two lines:
Column B == Column E
John Smith|TomGreen == Link1
Mary Davis|Susan Johnson|Bob Moore == Link2
Someone with intermediate knowledge of Excel should be able to complete this in 30 minutes or less.
Nº del proyecto: #8569498
Sobre el proyecto
34 freelancers están ofertando un promedio de $24 por este trabajo
Hi, I am an Excel VBA / formula expert and would happy to take on your project. Let me know and provide the source file. Regards, Arul
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project Más
Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards R Más
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before Más
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
I am an Excel expert and can do this with 100% accuracy. Please share the Excel file with me. Thanks!
Hello I can get the task done in the next 30 mins to 1 hour. Let me know if you are interested. Thanks
Hi, I am interested to work on your project. The requirements are clear. Please provide the source excel sheet to start the work. Regards, Rajesh.
Hi there! Have done this type of work before ! Please feel free to message me with additional information or with questions if any! Thanks! -Steve
I have the expertise in Excel and can do this task in less than 30 minutes, when you share the data file. Ready to start work immediately
Hi I am interested in this project. I can do this job for you. am an experienced VBA developer. if interested in hiring me then please let me know so that we can finalize it. Regards jawad
Hello. So, we need: 1. Find unique links; 2. Find names, correlated with these links, and show them in way you described? Is this correct? Let's deal :-)
A second worksheet will be created, the second worksheet will include the data in a different format. Half an hour work. Please share the file (recommended), if I am awarded. If that is not possible I will work w Más