how to create table of unique values with multiple categories(columns to match)

[aggie24193]

Hello All,
I have been searching to no avail.
I need a formula that lets me create a list of unique values but that has two columns. The first column has multiple categories like fruits and vegetables, and the second column has different kinds. Both columns currently have data that repeats. I understand how to get a single columns of unique values, but not multiple based on the first one.

A good example of where I am starting can be found here: https://www.extendoffice.com/documents/excel/4032-excel-dynamic-list-of-unique-values.html
But now let's pretend I have a column in front of the fruit one called produce and it lists fruit/vegetable and assigns the various values to it.

I hope I am being clear.
I want something that looks like:

Fruit Apple
Fruit Orange
Fruit Banana
Vegetable Squash
Vegetable Zucchini

ETC...

I am trying to use this formula to start: =IFERROR(INDEX($B$2:$B$9, MATCH(0,COUNTIF($D$1:D1, $B$2:$B$9), 0)),"")

 

[lrobbo314]

How about this formula below. It is an array formula to you have to hit Ctrl+Shift+Enter.

=IFERROR(INDEX($A$2:$A$9&"-"&$B$2:$B$9,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$9&"-"&$B$2:$B$9),0)),"")