Basic data manipulation with formulas or VBA

キャンセルされた 投稿 Sep 28, 2015 着払い
キャンセルされた 着払い

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.

エクセル

プロジェクトID: #8569498

プロジェクトについて

34個の提案 リモートプロジェクト アクティブ Sep 30, 2015

34人のフリーランサーが、平均$24 で、この仕事に入札しています。

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 1日以内
(165件のレビュー)
7.3
zExcel

A proposal has not yet been provided

$70 USD 1日以内
(249件のレビュー)
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 もっと

$24 USD 1日以内
(141件のレビュー)
7.1
P0L

A proposal has not yet been provided

$30 USD 1日以内
(242件のレビュー)
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 もっと

$25 USD 1日以内
(162件のレビュー)
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 もっと

$29 USD 1日以内
(95件のレビュー)
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 もっと

$15 USD 1日以内
(101件のレビュー)
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 0日以内
(238件のレビュー)
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 1日以内
(123件のレビュー)
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 0日以内
(96件のレビュー)
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 1日以内
(36件のレビュー)
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 もっと

$34 USD 1日以内
(70件のレビュー)
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 0日以内
(73件のレビュー)
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 1日以内
(64件のレビュー)
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 もっと

$20 USD 0日以内
(34件のレビュー)
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 1日以内
(22件のレビュー)
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 もっと

$20 USD 0日以内
(39件のレビュー)
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 1日以内
(18件のレビュー)
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 もっと

$10 USD 1日以内
(21件のレビュー)
4.5
shivaparvathi108

A proposal has not yet been provided

$10 USD 0日以内
(31件のレビュー)
4.2