怎么在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),","...
excel中如何把一列数据变成三列?答:A插入A列,编号 B列就是你要处理的数据 DEF就是你所求的列 最后复制DEF,不带公式黏贴数值就可以了 D列公式:=VLOOKUP(3*$A1-2,$A$1:$B$11,2,FALSE)E列公式:=VLOOKUP(3*$A1-1,$A$1:$B$11,2,FALSE)F列公式:=VLOOKUP(3*$A1,$A$1:$B$11,2,FALSE)...