sir,
please help to arrange the data in systematically.
Example file attached for your reference.
please help to arrange the data in systematically.
Example file attached for your reference.
Attachments

10.9 KB Views: 6
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)
) )