Sub test2()
Dim A, B, i, j, n, t
A = Range("a1:c" & Range("a65536").End(xlUp).Row)
n = 6
ReDim B(1 To UBound(A) / n, 1 To n + 1)
For i = 1 To UBound(B)
B(i, 1) = A((i - 1) * n + 1, 1)
For j = 2 To UBound(B, 2)
t = (i - 1) * n + j - 1
B(i, j) = A(t, 3)
Next j
Next i
[F2:L65536] = ""
[F2].Resize(i - 1, j - 1) = B
End Sub
2.rar
(90.94 KB, 下载次数: 8)