Retrieving non-zero cell from a range

[namy77]

Good morning,

I am trying to retrieve the non zero cell from a range of cells to a new column (please see table below).

I tried Index and Match with little result. Any recommendation would be appreciated!

Thanks,

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]->[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]->[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]->[/TD]
[TD]AA[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]8[/TD]
[TD]->[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Try,
I am assuming that there will only be on non zero value in the range.

Book1
	A	B	C	D	E
1	0	4	0	->	4
2	5	0	0	->	5
3	AA	0	0	->	AA
4	0	0	8	->	8
Sheet1

Cell Formulas
Range	Formula
E1	{=INDEX(A1:C1,SMALL(IF(A1:C1<>0,COLUMN(A1:C1)-COLUMN(A1)+1),1))}
E2	{=INDEX(A2:C2,SMALL(IF(A2:C2<>0,COLUMN(A2:C2)-COLUMN(A2)+1),1))}
E3	{=INDEX(A3:C3,SMALL(IF(A3:C3<>0,COLUMN(A3:C3)-COLUMN(A3)+1),1))}
E4	{=INDEX(A4:C4,SMALL(IF(A4:C4<>0,COLUMN(A4:C4)-COLUMN(A4)+1),1))}
Press CTRL+SHIFT+ENTER to enter array formulas.