Bosco_yip Sir,In G5, formula copied across and down :
=IFERROR(INDEX(($C:$C,$D:$D),AGGREGATE(15,6, ROW($B$5:$B$13)/($B$5:$B$13=$F5),INT((COLUMN(A$1)-1)/2)+1),0,MOD(COLUMN(A$1)-1,2)+1),"")
Or,
=IFERROR(INDEX($C$5:$D$13,AGGREGATE(15,6, ROW($B$5:$B$13)-ROW($B$4)/($B$5:$B$13=$F5),INT((COLUMN(A$1)-1)/2)+1),MOD(COLUMN(A$1)-1,2)+1),"")
View attachment 72992
= LAMBDA(tbl,
LET(
items, COUNTA(tbl),
k, SEQUENCE(1,items,0),
r, 1+QUOTIENT(k,2),
c, 1+MOD(k,2),
INDEX(tbl,r,c)
) )