單格多品類 二欄取不重複 (13477)

D2:I10=TRIM(MID(SUBSTITUTE($A2:$A10&"、"&$B2:$B10,"、",REPT(" ",19)),COLUMN(A1)*19-18,19))

K2{=IFERROR(INDIRECT(TEXT(MIN(IF((D$2:I$10<>"")*(COUNTIF(K$1:K1,D$2:I$10)=0),ROW($2:$10)/1%+COLUMN(D:I))),"!R0C00"),),"")