Sub test()
Dim A, d, k, t, r&, i&
'Range("A1").CurrentRegion.Sort KEY1:=[A1], Order1:=xlAscending, KEY2:=[B1], Order2:=xlAscending, Header:=xlYes
With Sheets(1)
r = .Cells(Rows.Count, 1).End(3).Row
A = .Range("A1:b" & r)
End With
Set d = CreateObject("scripting.dictionary")
For i = 2 To r
d(A(i, 1)) = d(A(i, 1)) & "," & A(i, 2)
Next i
k = d.keys: t = d.items
ReDim A(1 To UBound(k) + 1, 1 To 2)
For i = 1 To UBound(A)
A(i, 1) = k(i - 1)
A(i, 2) = Mid(t(i - 1), 2)
Next i
With Sheets(2).Range("a1")
.CurrentRegion = ""
.Resize(UBound(A), UBound(A, 2)) = A
End With
End Sub
如何批量已A列值的数据合并到表2单条A列对应的B列值(A)2.rar
(18.02 KB, 下载次数: 6)