=IF(ROW()>SUM($D$1:$D$15),"",INDEX(C$1:C$15,MATCH(ROW(D1),IF(ROW($1:$15)>1,SUMIF(OFFSET(D$1,,,ROW($1:$15)-1),">0")+1,1))))
按ctrl+shift+enter結束,下拉到出現空白單元格為止即可。
及時采納哦,親~
PS:這題竟然沒懸賞……