怎么在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引用一行数据到一列?答:1、先在K列右边插入空白辅助列 L 列,2、在 L1 输入公式:=IF($K$3="","",VLOOKUP($K$3&"*",Sheet2!C:C,1,0))在 L2输入公式:=IF($K$3="","",VLOOKUP($K$3&"*",OFFSET(Sheet2!C:C,MATCH($L1,Sheet2!C:C,0),0,MATCH($L1,Sheet2!C:C,0),1),1,0))选中 L2...