[Quote=引用 3 楼 laoyebin 的回复:]
Sub test()
Dim i%, j%, k%, arr()
For i = 2 To ActiveSheet.[a65536].End(xlUp).Row
For j = 1 To Cells(i, 2)
k = k + 1
ReDim Preserve arr(1 To k)
arr(k) = Cells(i, 1)
Next
Next
[e2].Resize(k, 1) = WorksheetFunction.Transpose(arr)
End Sub
Public Sub Exland()
Dim I, J, K As Integer
K = 1
For I = 2 To Sheet1.UsedRange.Rows.Count
For J = 1 To Sheet1.Cells(I, 2)
Sheet2.Cells(K, 1) = Sheet1.Cells(I, 1)
K = K + 1
Next J
Next I
End Sub
Sub test()
Dim i%, j%, k%, arr()
For i = 2 To ActiveSheet.[a65536].End(xlUp).Row
For j = 1 To Cells(i, 2)
k = k + 1
ReDim Preserve arr(1 To k)
arr(k) = Cells(i, 1)
Next
Next
[e2].Resize(k, 1) = WorksheetFunction.Transpose(arr)
End Sub