[COLOR=blue]Sub[/COLOR] CollerExam2()
Application.ScreenUpdating = [COLOR=blue]False[/COLOR]
[COLOR=blue]Dim[/COLOR] L [COLOR=blue]As Long[/COLOR], i [COLOR=blue]As Long[/COLOR]
L = Cells(Rows.Count, "A").End(xlUp).Row
Cells.NumberFormat = "@"[COLOR=green] ' Pas utile[/COLOR]
[COLOR=blue]For[/COLOR] i = L [COLOR=blue]To[/COLOR] 2 [COLOR=blue]Step[/COLOR] -1
[COLOR=blue]If[/COLOR] Trim(Cells(i, 1).Value) <> "" [COLOR=blue]And Not[/COLOR] Cells(i, 1).Value [COLOR=blue]Like[/COLOR] "0*" [COLOR=blue]Then[/COLOR]
Range("C2").Insert Shift:=xlDown
Range("C2").Value = Cells(i, 1).Value
Cells(i, 1).ClearContents[COLOR=green] '*[/COLOR]
[COLOR=green] '*Si vous voulez retrouver les valeurs en A regroupées:[/COLOR]
[COLOR=green] 'Cells(i, 1).Delete[/COLOR]
[COLOR=blue]End If[/COLOR]
[COLOR=blue]Next[/COLOR] i
Application.ScreenUpdating = [COLOR=blue]True[/COLOR]
[COLOR=blue]End Sub[/COLOR]