Completed

Two columns

I need to match and sort two excel columns of URL addresses. So that the matches are side by side in two columns

It is the ending string of the URL addresses that will match. The beginning parts vary.

Example row:

column a: Might have:

Mike/product/[login to view URL]

Column b:

http://store/day/Mike/product/1-12

The part that matches in those two rows is:

/Mike/product/1-12

So I’d want someone to sort the columns so that these matches are side by side

One person attempted to do this already by separating the trailing /directories into their own columns and sort and clean the data that way. Maybe you can do the same or some better way?

The purpose of this project is I will eventually make this a file I can use for redirecting old webpages to new pages with “301 redirects”

This is why I need the rows that match to be side by side. (Source URL, Target URL)

There will be some rows that don’t have a match and that’s fine.

Skills: Excel, Website Design, Data Cleansing, Data Extraction, Data Scraping

See more: building directories, comparison shopping use, arabic translation fine tune proz, blogs ready use, free 100 pr4 directories, ffmpeg use application, organizations use cold calling pakistan, use clone website, use joomla registrated virtuemart, templates use volusion, video site terms use, submission use private list directories, separating columns myspace, htaccess trailing slash directories, i have 36 statements that i need entered into excel the maximum number of entries per statement is 86 rows and two columns one c, write a c program to accept 10 or more numbers then display the numbers in two columns one column with the numbers as they were , write a c++ program to accept 10 or more numbers then: display the numbers in two columns: one column with the numbers as they w, imovie find the use a labview for five 5 of fine dining tom hardy

About the Employer:
( 0 reviews ) Rockledge, United States

Project ID: #21962339

Awarded to:

leelakalidas32

I have read your project details and i think i am the right person which you are looking for.i have done many same project, you can check my [login to view URL] is my guarantee,if you want free samples then ping me back. More

$50 USD in 1 day
(387 Reviews)
7.3

11 freelancers are bidding on average $108 for this job

sobujprantor

can you send the list to me? so i can do sample for you. message to me.

$100 USD in 3 days
(198 Reviews)
6.9
anzarulislam

Hello, This is ANZARUL ISLAM. I have read carefully the project description. I am Highly interested. I will do everything what do you want. I expect your response in My Inbox Message ! Thanks!

$140 USD in 7 days
(17 Reviews)
4.8
jinridong19713

Hello, sir Thank you for your job posting. I have read your post. I am an expert who have many experiences in Web scraping with python selenium, scrapy and bs4, PHP and nightmarejs.. In particular, I had great experie More

$50 USD in 7 days
(12 Reviews)
4.7
SEOandWRITERS

Dear Recruiter, We are a CA-based in-house Web/App Designing and Development Agency. We are a full stack team of website designers and developers having expertise in Designing, Developing Creating Database and Mainta More

$200 USD in 3 days
(11 Reviews)
5.0
Eng1

Hi hope my proposal find you in a good spirit If you need to see some samples of my works, please check my profile page on Freelancer.com https://www.freelancer.com/u/Eng1 My Skills: Arabic Translation Data en More

$40 USD in 3 days
(9 Reviews)
3.4
cooolwriter

Hi there, Your website designer and developer here. Graduated recently from Kings College, England ; I have been doing numerous Website and app design projects. I feel I will be comfortable to work with you and perfor More

$230 USD in 3 days
(3 Reviews)
3.3
Artemrodin1987

Hello, I have just read your requirement very careful and I am sure that I can finish it for 1 hours because I am a professional C/C++, Excel expert with strong algorithm. Now I don't have even one review because I am More

$140 USD in 7 days
(0 Reviews)
0.0
philgood2012

Hello, I have read your requirements instructions and fully understood it.I am a Microsoft certified technology specialist in Microsoft Office, Microsoft Excel, Word, and Access. I have a good command on data manageme More

$38 USD in 7 days
(0 Reviews)
0.0
DrakenBlade77

Hi there, I’ve checked the project details and I can do this project perfectly. I have huge experience in working with these projects. If you need sample work just send me a message. Waiting for your quick reply. A Bes More

$100 USD in 5 days
(0 Reviews)
0.0
lmariej94

I am detail-oriented and self-taught, with a bit of administrative assistant experience. I'll ensure your spreadsheet is well-organized, both accurately and quickly.

$100 USD in 5 days
(0 Reviews)
0.0