|
- Sub demo()
- Dim ar, re(), x, y, a, i, j
- Dim d As Object
- Set d = CreateObject("Scripting.Dictionary")
- ar = Sheet1.Range("h2:i" & Sheet1.Cells(Rows.Count, "h").End(3).Row)
- For i = 1 To UBound(ar)
- d(ar(i, 1)) = d(ar(i, 1)) & "-" & ar(i, 2)
- Next
- x = d.keys
- y = d.items
- ReDim re(1 To d.Count, 1 To 100)
- For i = 1 To d.Count
- re(i, 1) = x(i - 1)
- a = Split(y(i - 1), "-")
- For j = 1 To UBound(a)
- re(i, j + 1) = a(j)
- Next
- Next
- Sheet2.Range("h2").Resize(UBound(re), UBound(re, 2)) = re
- End Sub
复制代码 附件楼下
|
|