|
Sub Click()
Dim A(), B(), d As Object, i&, t$, s&, str$
Set d = CreateObject("scripting.dictionary")
A = Sheets(1).Range("a1").CurrentRegion.Value
ReDim B(1 To UBound(A), 1 To 3)
For i = 2 To UBound(A)
t = A(i, 5)
str = A(i, 1) & "," & A(i, 2) & "," & A(i, 3)
If d.exists(t) Then
B(s, 3) = B(s, 3) & "|" & str
Else
s = s + 1: d(t) = s
B(s, 1) = A(i, 4)
B(s, 2) = t
B(s, 3) = str
End If
Next i
With Sheets(2)
.Select
.Rows("2:65536").ClearContents
.Range("A2").Resize(s, UBound(B, 2)) = B
.Range("c2:c" & s).TextToColumns OtherChar:="|"
.Range("a1").CurrentRegion.Replace ",", vbCrLf
End With
End Sub
洽谈会顺序表2.rar
(23.67 KB, 下载次数: 3)
|
|