Bonjour,
une solution via une macro
Sub tri()
With Sheets("feuil1")
dl = .Cells(Rows.Count, 1).End(xlUp).Row
For i = 4 To dl
col = .Cells(i, 2) * 2 + 3
dlc = .Cells(Rows.Count, col).End(xlUp).Row + 1
.Cells(dlc, col) = .Cells(i, 1)
Next i
End With
End Sub