Sub trie()
Dim derlgn As Byte, Col As Byte, C As Byte, L As Byte
Dim tabtemp As Variant
Dim item As Variant
With Worksheets('Feuil1')
derlgn = .Range('B100').End(xlUp).Row
tabtemp = .Range(.Cells(2, 2), .Cells(derlgn, 3))
For Col = 5 To 10
For Each item In Array('A', 'B', 'C', 'D', 'E')
For L = 1 To UBound(tabtemp, 1)
If tabtemp(L, 2) = item Then
derlgn = .Cells(100, Col).End(xlUp).Row + 1
.Cells(derlgn, Col) = tabtemp(L, 1)
End If
Next L
Col = Col + 1
Next item
Next Col
End With
End Sub