Hi,

Instead of using array formulas, I'd do a very quick Pivot Table and drag the Fruit to the Row box. Then you can copy and paste, using values only the unique values in the fruit column. No formulas needed if you know about Pivot Tables.