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:

Column A Apple Lemon Papaya Orange

Column Q Apple-Lemon Lemon-Papaya Papaya-Apple Orange-Papaya

<tbody>
</tbody>

Thanks in advanced for helping me
Amira