Sub chuyendulieu()
Dim arr, i As Long, lr As Long, dic As Object
Set dic = CreateObject("scripting.dictionary")
With Sheets("Issue")
lr = .Range("C" & Rows.Count).End(xlUp).Row
arr = .Range("c2:D" & lr).Value
For i = 1 To UBound(arr, 1)
If Not dic.exists(arr(i, 1)) Then
dic.Add arr(i, 1), arr(i, 2)
Else
dic.Item(arr(i, 1)) = dic.Item(arr(i, 1)) & "-" & arr(i, 2)
End If
Next i
End With
With Sheets("Data")
lr = .Range("i" & Rows.Count).End(xlUp).Row
arr = .Range("i2:Y" & lr).Value
For i = 1 To UBound(arr, 1)
If dic.exists(arr(i, 1)) Then
arr(i, 17) = dic.Item(arr(i, 1))
End If
Next i
.Range("i2:Y" & lr).Value = arr
End With
Set dic = Nothing
End Sub