I am currently conducting a content audit to identify duplicates between pages using Screaming Frog.
However, I am having trouble with the results when exporting URL data. The data displayed in the spreadsheet is roughly like this:
| Column A | Column B |
|---|---|
| stackoverflow. com/home-furniture/ | stackoverflow. com/house-furniture/ |
| stackoverflow. com/house-furniture/ | stackoverflow. com/home-furniture/ |
The only difference between row 1 and row 2 is the position. I want to remove the duplicates. Can you help me with this for a large dataset?
What formula or script can be used to solve this problem in spreadsheet?