Hey guys, I don't really know how to explain this but, yes I would like to get the different headings from a list in a table.
For example,
(sheet1) (A1:B11)
Fruits Number
Bananas 100
Apples 200
Bananas 300
Mangoes 400
Peaches 200
Pineapples 10
Mangoes 20
Peaches 30
Watermellons 3
I would like to get the different kind of fruits in a separate table, but instead of going through them one by one, I would like to have a formula which actually gets all the headings (excluding the repeated ones).
Help please!
Bookmarks