如何将EXCEL中的两行多列数值变成多行一列的数值,且要求两个两个排列...答:SHEET2 A1中输入或复制粘贴下列公式之一:=INDIRECT("SHEET1!R"&MOD(ROW(A2),2)+1&"C"&CEILING(ROW(A1)/2,1),)=INDIRECT("SHEET1!"&ADDRESS(MOD(ROW(A2),2)+1,CEILING(ROW(A1)/2,1)))=INDEX(SHEET1!$A$1:$J$2,MOD(ROW(A2),2)+1,CEILING(ROW(A1)/2,1))=OFFSET(SHEET1!