The "Flatten" Formula worked perfectly for me. I was attempting to consolidate all of my data into 1 column and find only the unique values.