Sub 逐一引用()
Application.ScreenUpdating = False
Range("E4:Z65536").ClearContents
Dim arr, dic As Object, i&, j&, kk, tt
Set dic = CreateObject("scripting.dictionary") '
arr = Range("A2:B" & Range("B65536").End(3).Row)
ReDim brr(1 To UBound(arr), 0 To 50)
For i = 1 To UBound(arr)
If Len(arr(i, 2)) Then
If Len(arr(i, 1)) Then
dic(arr(i, 1)) = dic(arr(i, 1)) & "," & arr(i, 2)
w = arr(i, 1)
Else
dic(w) = dic(w) & "," & arr(i, 2)
End If
End If
Next
kk = dic.keys: tt = dic.Items
For j = 0 To UBound(kk)
ee = Split(tt(j), ",")
For k = 0 To UBound(ee)
brr(j + 1, k) = ee(k)
Next
brr(j + 1, 0) = kk(j)
Next
[E4].Resize(UBound(kk) + 1, 50) = brr
Application.ScreenUpdating = True
End Sub