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...[TABLE="width: 640"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[TD]YES[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]111[/TD]
[TD]222[/TD]
[TD]333[/TD]
[TD]444[/TD]
[TD]555[/TD]
[TD]666[/TD]
[TD]777[/TD]
[TD]888[/TD]
[TD]999[/TD]
[TD]521[/TD]
[/TR]
</tbody>[/TABLE]

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 ?