|
你就再提取一次吧。
Sub TEST()
D = 1
ARR = Range("A1:A" & Range("A65536").End(3).Row)
ReDim T(1 To 1)
T(D) = ARR(1, 1)
Z = ARR(1, 1)
For I = 2 To UBound(ARR)
If ARR(I, 1) = Z Then
T(D) = T(D) & Chr(10) & ARR(I, 1)
Else
D = D + 1
ReDim Preserve T(1 To D)
T(D) = ARR(I, 1)
Z = ARR(I, 1)
End If
Next
Sheets(2).Range("A1").Resize(1, UBound(T)) = T
D = 1
ARR = Range("B1:B" & Range("B65536").End(3).Row)
ReDim T(1 To 1)
T(D) = ARR(1, 1)
Z = ARR(1, 1)
For I = 2 To UBound(ARR)
If ARR(I, 1) = Z Then
T(D) = T(D) & Chr(10) & ARR(I, 1)
Else
D = D + 1
ReDim Preserve T(1 To D)
T(D) = ARR(I, 1)
Z = ARR(I, 1)
End If
Next
Sheets(2).Range("A5").Resize(1, UBound(T)) = T
End Sub |
|