Sub tri()
Dim T(), DerLig As Long
Application.ScreenUpdating = False
[C:C].ClearContents
DerLig = Range("B" & Rows.Count).End(xlUp).Row
T = Range("A1:B" & DerLig)
Range("A1:B" & DerLig).Sort Key1:=Range("B1"), Order1:=xlAscending, _
Key2:=Range("A1"), Order2:=xlAscending, Header:=xlGuess
For i = 1 To DerLig
Cells(i, 3).FormulaR1C1 = "=RC[-1]&"" ""&RC[-2]"
Next i
With Range("C1:C" & DerLig)
.Copy
.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End With
With [A1]
.Select
.Resize(UBound(T), UBound(T, 2)) = T
End With
Application.ScreenUpdating = True
End Sub