二欄轉換多欄多行 (13970)

F2:F5{=INDEX(B:B,SMALL(IF(A$2:A$12=F$1,ROW($2:$12),99),ROW(A1)))&""

G2:J5=SUMPRODUCT(N(+$B$2:$B$12)*(LOOKUP(ROW(2:12),ROW(2:12)/ISERR(-$B$2:$B$12),$B$2:$B$12)=$F2)*($A$2:$A$12=G$1))