FILTER and extract a column

[p45cal]

Headers (S1):
=CHOOSECOLS(Table1[#Headers],1,H2)

databody (S2):
=FILTER(CHOOSECOLS(Table1,1,H2),Table1[AAA]=G2,"No "&G2)

and in one (V1):
=LET(ColmAFltr,G2,ColmNo,H2,VSTACK(CHOOSECOLS(Table1[#Headers],1,ColmNo),FILTER(CHOOSECOLS(Table1,1,ColmNo),Table1[AAA]=ColmAFltr,"No "& ColmAFltr)))

full lambda (not needed but for development) (Y1):
=LAMBDA(ColmAFltr,ColmNo,VSTACK(CHOOSECOLS(Table1[#Headers],1,ColmNo),FILTER(CHOOSECOLS(Table1,1,ColmNo),Table1[AAA]=ColmAFltr,"No "& ColmAFltr)))(G2,H2)

Put the red part as a name into Name Manager leaving you with (AB1):
=MyNewTable(G2,H2)