复制粘贴的单元格每粘贴4个单元格就会更改列

您是否愿意使用公式来达到目标​​？（而不是复制/粘贴）

该公式可以放在目标表的所有单元格中。您需要根据电子表格调整源锚点（$B$3）和目标锚点（$F$3）和宽度（4）。

Even if you want "values" in the destination cells rather than "formulas", this is still probably the best approach... use the formula and then flatten the cells to values (use Copy / Paste Special → Values).

=INDIRECT(ADDRESS(((ROW()-ROW($F$3))*4)+(COLUMN()-COLUMN($F$3))+ROW($B$3),COLUMN($B$3)))

1. Produce the source row
   • ROW()-ROW($F$3) - get the zero-based row of the destination table
     • ROW() - row of "this" cell
     • ROW($F$3) - first row of the destination table
   • *4 - multiply by number of columns in destination table
   • +(COLUMN()-COLUMN($F$3)) - add the column of the destination table
     • COLUMN() - column of "this cell, numeric and 1-based
     • COLUMN($F$3) - first column of the destination table
   • +ROW($B$3) - add the row of the source table
     • ROW($B$3) - first row of the source data
2. Get the address of the source cell
   • ADDRESS(..., COLUMN($B$3)) - row from step 1, and source column
3. 通过地址获取值
   • INDIRECT(...) -使用第2步中的地址