Formula that returns different values based on same event

[jlucky44]

I need to find a formula that returns the bold number when 1 happens

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

So my goal would be to return in separate columns:

[TABLE="width: 500"]
<tbody>[TR]
[TD]3[/TD]
[TD]6[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]

I was thinking about index/match - but in this case it wouldn't work, but maybe there is a variation of the function I'm not aware of.

 

[Aladin Akyurek]

In A4 control+shift+enter, not just enter, and copy across:

=IFERROR(INDEX($A$1:$J$1,SMALL(IF($A$2:$J$2=1,COLUMN($A$1:$J$1)-COLUMN($A$1)+1),COLUMNS($A$4:A4))),"")