In Excel, I have a table where I want to list all unique values from a column in a different a row of a different sheet. Here is an example of the data I have:
I want to fill in cells in the other sheet so that it gives all of the different options for the favorite fruit. It would look something like this:
Apple | Banana | Grapefruit | Orange
How do I loop through the options (shown below) to make this happen?
Best Answer
Check this article that explains to get unique values from a list. Differently, it creates a vertical list however, formula will work as horizontal as well. However; you should add | characters by yourself, I mean by using another formula.
Unique list formula is
which
After tying formula, all you need to do is copy the formula to right cells.