Formula that returns different values based on same event

[jlucky44]

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

1	2	3	4	5	6	7	8	9	10
0	0	1	0	0	1	0	0	1	0

<tbody>
</tbody>

So my goal would be to return in separate columns:

3

6

9

<tbody>
</tbody>

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))),"")