I have a spreadsheet with 2 columns. 1 column has 50 entries, the other has 80. They are stock symbols. I want to “walk” the lists and get all of the unique values from the 2 columns and put them in a 3rd column.
Would yield: AAA, BBB, CCC, DDD
If I was querying data tables, I could probably do a join, but I’m not sure how to do this with a spreadsheet.