Basic data manipulation with formulas or VBA

Cancelado Publicado Sep 28, 2015 Pagado a la entrega
Cancelado 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.

Excel

Nº del proyecto: #8569498

Sobre el proyecto

34 propuestas Proyecto remoto Activo Sep 30, 2015

34 freelancers están ofertando un promedio de $24 por este trabajo

deepbluetech

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

$30 USD en 1 día
(165 comentarios)
7.3
zExcel

A proposal has not yet been provided

$70 USD en 1 día
(249 comentarios)
7.6
someka

You dont need to recruit me now. Drop me a message and i can make a free trial study for you. If you get happy, we can proceed. (as i want more references in my profile, i provide this service) I have a 5,5 years of Más

$24 USD en 1 día
(141 comentarios)
7.1
P0L

A proposal has not yet been provided

$30 USD en 1 día
(242 comentarios)
7.0
cugamelover

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

$25 USD en 1 día
(162 comentarios)
7.0
raghav1101

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

$29 USD en 1 día
(95 comentarios)
6.5
rohitpithisaria

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

$15 USD en 1 día
(101 comentarios)
6.3
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene

$13 USD en 0 días
(238 comentarios)
6.3
best4best

I am an Excel expert and can do this with 100% accuracy. Please share the Excel file with me. Thanks!

$20 USD en 1 día
(123 comentarios)
6.3
gokulanand

Hello I can get the task done in the next 30 mins to 1 hour. Let me know if you are interested. Thanks

$20 USD en 0 días
(96 comentarios)
6.0
RRajeshR

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.

$30 USD en 1 día
(36 comentarios)
6.0
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Más

$34 USD en 1 día
(70 comentarios)
5.8
catstevens2009

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

$25 USD en 0 días
(73 comentarios)
5.5
surekash7096

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

$25 USD en 1 día
(64 comentarios)
5.2
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio Más

$20 USD en 0 días
(34 comentarios)
4.9
jawadaman

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

$35 USD en 1 día
(22 comentarios)
4.5
ElaineTeo

I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thi Más

$20 USD en 0 días
(39 comentarios)
4.5
piekn

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 :-)

$15 USD en 1 día
(18 comentarios)
4.4
serdaryalcin

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

$10 USD en 1 día
(21 comentarios)
4.5
shivaparvathi108

A proposal has not yet been provided

$10 USD en 0 días
(31 comentarios)
4.2