Transposing, Filtering Data... kinda...

Hi,

You can use INDEX MATCH arrays.

Enter in C14 and copy down.

=INDEX($C$3:$G$7,MATCH($B$13,$B$3:$B$7,0),MATCH($B14,$C$2:$G$2,0))

Enter in D21 and copy down.

=INDEX($C$3:$G$7,MATCH($B21&$C21,$A$3:$A$7&$B$3:$B$7,0),MATCH($B$20,$C$2:$G$2,0))

These are arrays, use CTRL, SHIFT, ENTER when entering them.

See attachment.

Hope this is helpful.

Cheers