Pl Check Screenshot and attached. It is easy to do in 10.3 with join Calculation on 1. I did this in 10.1, so created another file with your fruit names and joined it to your original data on 1:1 as cartesian join. and set up a filter to give you what is desired.If it Helps, please mark Helpful and CORRECT.
Multiple.twbx 24.6 KB