Need help with making complex formula

[locksmith55]

Hello,

I am trying to make a formula that goes from row to row and left to right to check if the cell is equal to 1. If the cell is equal to 1, then I want to print the number that's below the cell.

I added a picture to illustrate what I mean.

Appreaciate any help I can get. I have been trying to solve this for a while now with no success.

I would appreciate if the formula is not too complex.

mr excel 7 30.xlsx
	A	B	C	D	E	F	G
1	Group 1	Group 2	Group 3		HOW I WANT IT TO LOOK
2	1	0	1		UPS0711AB		<- I want dynamic formula that can recreate this result
3	1	0	0		ABC12A0777
4	1	0	0		UPS0711AB
5	0	0	0		UPS0711AB
6	1	0	0		UPS0711AB
7	1	0	1		UPS0711AB
8	1	0	1		ABC12A0777
9	0	0	1		UPS0711AB
10	UPS0711AB		ABC12A0777		ABC12A0777
11					ABC12A0777
Sheet1

Cell Formulas
Range	Formula
E2	E2	=A10
E3	E3	=C10
E4	E4	=A10
E5	E5	=A10
E6	E6	=A10
E7	E7	=A10
E8	E8	=C10
E9	E9	=A10
E10	E10	=C10
E11	E11	=C10

 

[Eric W]

How about:

Book1
	A	B	C	D	E
1	Group 1	Group 2	Group 3		HOW I WANT IT TO LOOK
2	1	0	1		UPS0711AB
3	1	0	0		ABC12A0777
4	1	0	0		UPS0711AB
5	0	0	0		UPS0711AB
6	1	0	0		UPS0711AB
7	1	0	1		UPS0711AB
8	1	0	1		ABC12A0777
9	0	0	1		UPS0711AB
10	UPS0711AB		ABC12A0777		ABC12A0777
11					ABC12A0777
12
Sheet3

Cell Formulas
Range	Formula
E2:E11	E2	=LET(rng,A2:C9,lbl,A10:C10,r,ROWS(rng),c,COLUMNS(rng),s,SEQUENCE(r*c,,0),t,INDEX(rng,INT(s/c)+1,MOD(s,c)+1),a,INDEX(lbl,MOD(s,c)+1),FILTER(a,t=1))
Dynamic array formulas.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1	Group 1	Group 2	Group 3		HOW I WANT IT TO LOOK
2	1	0	1		UPS0711AB
3	1	0	0		ABC12A0777
4	1	0	0		UPS0711AB
5	0	0	0		UPS0711AB
6	1	0	0		UPS0711AB
7	1	0	1		UPS0711AB
8	1	0	1		ABC12A0777
9	0	0	1		UPS0711AB
10	UPS0711AB		ABC12A0777		ABC12A0777
11					ABC12A0777
Main

Cell Formulas
Range	Formula
E2:E11	E2	=LET(Rng,A2:C9,a,IFERROR(INDEX(A10:C10,IF(Rng=0,"",Rng),{1,2,3}),""),c,COLUMNS(Rng),s,SEQUENCE(ROWS(Rng)*c,,0),b,INDEX(a,INT(s/c)+1,MOD(s,c)+1),FILTER(b,b<>""))
Dynamic array formulas.