E1=LOOKUP(1,0/(A$1:A1<>""),A$1:A1)&LOOKUP(1,0/(B$1:B1<>""),B$1:B1)&LOOKUP(1,0/(C$1:C1<>""),C$1:C1)向下复制
E1单元输入：=LOOKUP(1,0/(A$1:A1<>""),A$1:A1)&LOOKUP(1,0/(B$1:B1<>""),B$1:B1)&C1下拉公式
