不重複取出 空白不取 (13762)

G2{=IFERROR(OFFSET(D$1,MATCH(,COUNTIF(G$1:G1,D$2:D29)/(D$2:D29<>""),),),"")

H2=IF(G2="","",SUMIF(D:D,G2,E:E))

G2另解{=INDEX(D:D,SMALL(IF(D$2:D29="",ROW($1:28),99),ROW(A1)),)&""