excel里如何将一个单元格里的内容拆成多个,并且复制同一行内容到下一行...答:如果P列每个单元格的数据个数是相同的则公式可以如下 A1单元格输入公式 =TRIM(MID(SUBSTITUTE(OFFSET(P$1,INT((ROW(A1)-1)/(LEN(P$1)-LEN(SUBSTITUTE(P$1,",",""))+1)),),",",REPT(" ",99)),(1+MOD(ROW(A1)-1,LEN(P$1)-LEN(SUBSTITUTE(P$1,",",""))+1))*100-99,...
Excel 如何实现一对多的转置?答:参考此方法,加两个辅助列 h1=--(ROW()&TEXT(COUNTA(B1:G1),"00"))下拉 i1=MIN(H:H)i2=IFERROR(IF(ROW()-MATCH(I1,I$1:I1,0)<--RIGHT(I1,2),I1,SMALL(H:H,COUNTIF(H:H,"<="&I1)+1)),"")下拉,j1=IF(I1="","",INDEX(A:A,INT(I1/100)))下拉 k1=IF(I1...