Need formula for to display overall concatenate value

[suyogpat]

Hi Guys,

I need your expert help in one formula.

So in below table i have headers,"YES" &"NO" and value of the respective YES and no.

What i am trying to achieve here is in input cell when i enter Yes so it should display all YES value in single cell (it should be like YES-111,YES-333,YES-555,YES-777 and when No will be in input cell it should mentioned No-222,No-444,No-666 and so on...

<tbody>
</tbody>

A	B	C	D	E	F	G	H	I	J
YES	NO	YES	NO	YES	NO	YES	NO	YES	NO
111	222	333	444	555	666	777	888	999	521

<tbody>
</tbody>

I tried many ways of Hlookup and others but no luck with my limited knowledge, so thought to ask experts now.
Thank you in advance for your help

 

[BGY23]

You're welcome. Thanks for the feed back.

 

[James006]

@ suyogpat

How are you going to handle future situations ... with less or more Columns than your current ten columns ?