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.
column a: Might have:
Mike/product/[login to view URL]
The part that matches in those two rows is:
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.
11 freelancers are bidding on average $108 for this job
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!
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.