I've tried "Unique" and "Filter" in Google Sheets but so far it's not been easy. Maybe I'm overthinking it. I'd like to remove a set of duplicates from a list of names in two separate columns. The challenge is that the repeated items are in opposite columns as shown below. I'd like, if possible, to remove the repeated items under the horizontal line. The colors show the same names but in reverses. The desired result is the two columns on the right.
Appreciate any feedback.