If your data are on Sheet1, then fill in Sheet2!A1 with =INDIRECT("Sheet1!R" & (COLUMN()-1)*55+MOD(ROW()-1,55)+1 & "C1", FALSE). Drag/fill this down to row ...
確定! 回上一頁