Populate dynamic list of row or column items based on table value.

Occasional Visitor

joshua935_3-1627690975042.png

 

 

 

Hi everyone, 

I am trying to generate two lists based on a "y" or "n" value in the table. The image above shows my desired result in red box. any help would be great.

1 Reply

@joshua935 

Maybe this...

 

In H4

=SORT(FILTER(B5:B8,INDEX(C5:E8,,MATCH(H$3,$C$4:$E$4,0))="y"))

 

In J4

=SORT(TRANSPOSE(FILTER(C4:E4,INDEX(C5:E8,MATCH(J$3,$B$5:$B$8,0),)="y")))