I am trying to merge 2 fields into 1. Here's the scenario - I am trying to scrape data from a site that has a product list and some of those products are on sale. The products that are on sale have an additional element titled "Best Price", which causes the product name's xPath position to change.
I have resolved this by clicking both the regular product name and the product name that is on sale and then selecting all the similar items. Now the regular product name is coming on one field/column and the sale product name is coming on a second field/column. I would like to merge these into a single field/column that contains all the product names.
Please let me know how to do this.
Please sign in to leave a comment.