- Dim arr, brr, crr, drr, d As Object, i&, j&, x
- Set d = CreateObject("scripting.dictionary")
- arr = [a15:b22]
- brr = [d15:e22]
- crr = [g15:h22]
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = arr(i, 2)
- Next
- For i = 1 To UBound(brr)
- d(brr(i, 1)) = d(brr(i, 1)) & "," & brr(i, 2)
- Next
- For i = 1 To UBound(crr)
- d(crr(i, 1)) = d(crr(i, 1)) & "," & crr(i, 2)
- Next
- ReDim drr(1 To d.Count, 1 To 4)
- a = d.keys: b = d.items
- For i = 0 To d.Count - 1
- drr(i + 1, 1) = a(i)
- x = Split(b(i), ",")
- For j = 0 To UBound(x)
- drr(i + 1, j + 2) = x(j)
- Next
- Next
- Range("a27").Resize(UBound(drr), UBound(drr, 2)) = drr
复制代码 |