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,

A	B	C		D
0	4	0	->	4
5	0	0	->	5
AA	0	0	->	AA
0	0	8	->	8

<tbody>
</tbody>

 

[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.