H1输入1或者0
H2=COUNTA(B$1:G1)+1向下复制到数据的下一行
A6=IF(ROW(A1)<$H$4,LOOKUP(ROW(A1),$H$1:$H$3,$A$1:$A$3),"")向下复制
B6=IF(A6="","",VLOOKUP($A6,$A$1:$G$3,COUNTIF(A$6:A6,A6)+1,0))向下复制
H1输入1或者0
H2=COUNTA(B$1:G1)+1向下复制到数据的下一行
A6=IF(ROW(A1)<$H$4,LOOKUP(ROW(A1),$H$1:$H$3,$A$1:$A$3),"")向下复制
B6=IF(A6="","",VLOOKUP($A6,$A$1:$G$3,COUNTIF(A$6:A6,A6)+1,0))向下复制
