Hi guys,
I've crawled a website and each product has numerous URL versions (due to different URL structures). See examples below:
www.test.com.au/firepit-30cm-black
www.test.com.au/heating/firepit-30cm-black
www.test.com.au/heating/outdoor-heating/firepit-30cm-black
www.test.com.au/fire-pits/firepit-30cm-black
www.test.com.au/heating/fire-pits/firepit-30cm-black
Each of these URLs are in separate cells at the moment, but I want them to be merged into one cell with line breaks.
Is there a formula to merge these into the one cell with line breaks, based on the parameter "/firepit-30cm-black"?
We've got to roll this out for all products across the site so we need a formula rather than taking a manual approach.
There also isn't a set number of URL versions, so some products might have 3 URLs and other product might have 6 URLs.
The only consistent parameter in the URL structure is the product name (eg. "firepit-30cm-black").
Any help would be appreciated!
Cheers,
Jazz
I've crawled a website and each product has numerous URL versions (due to different URL structures). See examples below:
www.test.com.au/firepit-30cm-black
www.test.com.au/heating/firepit-30cm-black
www.test.com.au/heating/outdoor-heating/firepit-30cm-black
www.test.com.au/fire-pits/firepit-30cm-black
www.test.com.au/heating/fire-pits/firepit-30cm-black
Each of these URLs are in separate cells at the moment, but I want them to be merged into one cell with line breaks.
Is there a formula to merge these into the one cell with line breaks, based on the parameter "/firepit-30cm-black"?
We've got to roll this out for all products across the site so we need a formula rather than taking a manual approach.
There also isn't a set number of URL versions, so some products might have 3 URLs and other product might have 6 URLs.
The only consistent parameter in the URL structure is the product name (eg. "firepit-30cm-black").
Any help would be appreciated!
Cheers,
Jazz