Excel中如何将多行6列文件变成多行4列文件?答:SHEET2工作表任一单元格 =OFFSET(Sheet1!$A$1,INT((ROW(A1)-1)/3)*2+CHOOSE(MOD(ROW(A3),3)+1,,IF(OR(MOD(COLUMN(A1),4)={1,2}),,1),1),COLUMN(A1)+CHOOSE(MOD(ROW(A3),3)+1,-1,CHOOSE(...
表格中如何将一列4个选项转换成4列答:B2输入 =MID(A2,FIND("A.",A2)+2,FIND("B.",A2)-FIND("A.",A2)-2)C2输入 =MID(A2,FIND("B.",A2)+2,FIND("C.",A2)-FIND("B.",A2)-2)D2输入 =MID(A2,FIND("C.",A2)+2,FIND("D...