每5行转置到一行
试下这个 VBA
Sub aa()
Dim I
For I = 7 To Range("a65536").End(xlUp).Row Step 6
Range(Cells(I, "a"), Cells(I + 5, "a")).Select
Selection.Copy
Cells(Range("F65536").End(xlUp).Row + 1, "f").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Next
End Sub
追问因为数据量大,一个一个转置太费事了。有什么方法吗?
追答已回答
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100af3d535d628b4710b9122f2c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb337b8dcebc933c895d1430c2c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问是每6行转置到一行
追答是的6行转置,步长为 6
是,步长为 6