每行最多只有4个数据,用公式霸点蛮:
=TRIM(MID(SUBSTITUTE("+"&TEXT(INDEX($1:$1,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),1)),"M-D")&"*"&INDEX(2:2,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),1))&"+"&TEXT(INDEX($1:$1,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),2)),"M-D")&"*"&INDEX(2:2,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),2))&"+"&TEXT(INDEX($1:$1,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),3)),"M-D")&"*"&INDEX(2:2,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),3))&"+"&TEXT(INDEX($1:$1,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),4)),"M-D")&"*"&INDEX(2:2,SMALL(IF(A2:H2<>"",COLUMN(A:H),8),4)),"+",REPT(" ",99),COUNTA(A2:H2)+1),2,90))
公式以CTRL+SHIFT+ENTER三键结束。