J2 下拉=OFFSET(A$2,MOD(ROW(A1)-1,COUNTA(A:A)),)&""
K2下拉=IF(J2="","",OFFSET(B$2,MOD(INT((ROW(A1)-1)/COUNTA(A:A)),COUNTA(B:B)-1),))
L2 下拉=IF(J2="","",OFFSET(C$3,INT((ROW(A1)-1)/(COUNTA(A:A)*(COUNTA(B:B)-1))),))
M2 下拉=IF(J2="","","【薄款短裤】"&J2&"-黑短裤/"&C$2&"+"&K2&"/"&L2) |