怎么将excel一行里数据变成一列?答:如图 如图,f1=IF(ROUNDUP(ROW()/3,0)>COUNT(A:A),"",IF(MOD(ROW(),3)=1,ROUNDUP(ROW()/3,0),""))g1=IF(ROW()>COUNTA(B:D),"",INDEX(B:D,ROUNDUP(ROW()/3,0),MOD(ROW()-1,3)+1))选中f1和g1下拉
怎么在EXCEL中把一行变成多列?答:假设原数据在A和B列,如图:F2公式:=TRIM(MID(SUBSTITUTE(SUBSTITUTE(PHONETIC(B$2:B$100),",",""),"c",REPT(" ",LEN(SUBSTITUTE(PHONETIC(B$2:B$100),",","")))&"c"),LEN(SUBSTITUTE(PHONETIC(B$2:B$100),",",""))*ROW(A1)+1,LEN(SUBSTITUTE(PHONETIC(B$2:B$100),","...