|
发表于 2016-8-10 18:57
|
显示全部楼层
本楼为最佳答案
Sub TEST()
d = 1
r = Sheet1.Range("A65536").End(3).Row
ARR = Sheet1.Range("A1:A" & r)
ReDim t(1 To 2, 1 To UBound(ARR))
t(1, d) = ARR(1, 1)
Z = ARR(1, 1)
For i = 2 To UBound(ARR)
If ARR(i, 1) = Z Then
t(1, d) = t(1, d) & Chr(10) & ARR(i, 1)
Else
d = d + 1
' ReDim Preserve t(1 To d)
t(1, d) = ARR(i, 1)
Z = ARR(i, 1)
End If
Next
d = 0
For i = 1 To UBound(t, 2)
If Len(t(1, i)) > 1 Then
d = d + 1
t(2, d) = t(1, i)
End If
Next
Sheets(2).Range("A1").Resize(2, UBound(t, 2)) = t
End Sub |
|