Multiple Unique Value Return

[izk630]

I am trying to get these results display on columns rather than rows. I found the solution for this but without entering the countif part which makes the results skip duplicate values.
I want the results displayed in cells E10,F10,G10, etc instead of E10,E11,E12, etc

thankstest1.xls

[Ace_XL]

In E10

=INDEX(Item, SMALL(IF(($C$10=Category)*(COUNTIF($D$10:D10,Item)=0), ROW(Category)-MIN(ROW(Category))+1, ""), 1))

Array entered

Copy across

[izk630]

It does not work. It repeats the word Espresso on every cell. The result should be only Espresso once and Americano once just like in the rown

[Czeslaw]

It may suitable.

[izk630]

thank you this works