Nov 10 2020 12:21 AM
Nov 10 2020 04:39 AM
Nov 10 2020 07:42 AM
I see now that you have several columns. Something like this might work
=LET(mtx,FILTER(Sheet1!B:E,A2=Sheet1!A:A),
rCount,ROWS(mtx),
cCount,COLUMNS(mtx),
mCount,rCount*cCount,
INDEX(mtx,QUOTIENT(SEQUENCE(,mCount),rCount)+1,MOD(SEQUENCE(,mCount,0),cCount)+1))
(make one row if you prefer that)