Do not know the exact formula for this output

[Miss N]

Hi all,

Before this, i just get the number for the info that i want, like right now i need the information in column itself.
Formula that i used to get the data
=COUNTIF(Q:Q,"*"&Apple&"*") so i got 2.

I would like to get the output Like "Apple = Apple-Lemon, Papaya-Apple."
Means that, find all the data in specific column only. I want Apple, and the output will come out all the data that related to Apple.

For example:
[TABLE="class: grid, width: 150"]
<tbody>[TR]
[TD]Column A
Apple
Lemon
Papaya
Orange[/TD]
[/TR]
[TR]
[TD]Column Q
Apple-Lemon
Lemon-Papaya
Papaya-Apple
Orange-Papaya[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advanced for helping me
Amira