Finding common text strings between 2 columns

[richb01]

Hi!

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.

Example:

AAA BBB

CCC DDD

BBB CCC

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.

TIA!

[dajare]

@mariosv’s answer in a duplicate Q&A looks very simple, and worked perfectly in my wee test. It uses the Menu > Data > Consolidate… feature.

[JohnSUN]

This is not a very difficult task