I have a spreadsheet with multiple rows and columns. In each row and column,
the cells contain one or more the same data for example
A B C ....
1 Orange USA A2
2 Apple USA B1
3 Orange Canada C1l
4 Oragne USA A2
5 Peach Canada A1
6 Apple USA A2

I need a function or combination of function to ONLY list ONE occurance of
each. In the example. Col A will list "Orange, Apple Peach", Col B lists
"USA, Canada"

Regards