Sub test()
Dim arr, x, y, k, arr1(1 To 1000, 1 To 2)
Dim d As New Dictionary
arr = Range("a1").CurrentRegion.Value
For x = 2 To UBound(arr)
If d.Exists(arr(x, 4)) Then
k = d(arr(x, 4))
arr1(k, 2) = arr1(k, 2) & arr(x, 3)
Else
y = y + 1
d.Add arr(x, 4), y
arr1(y, 1) = arr(x, 4)
arr1(y, 2) = arr(x, 3)
End If
Next
Range("h2:i65536").ClearContents
Range("h2").Resize(y, 2) = arr1
End Sub
副本报表.rar
(9.34 KB, 下载次数: 152)