Bonsoir Shinsky
A tester :
Option Explicit
Sub test()
Dim a, b(), i As Long, j As Long, n As Long
a = Sheets("Feuil1").Range("a1").CurrentRegion.Value
ReDim b(1 To UBound(a, 1) * (UBound(a, 2) - 1), 1 To 2)
For i = 1 To UBound(a, 1)
For j = 2 To UBound(a, 2)
If a(i, j) <> "" Then
n = n + 1
b(n, 1) = a(i, 1)
b(n, 2) = a(i, j)
End If
Next
Next
Application.ScreenUpdating = False
With Sheets("Feuil2").Cells(1)
.CurrentRegion.Clear
With .Resize(n, UBound(b, 2))
.Value = b
.Font.Name = "calibri"
.VerticalAlignment = xlCenter
.BorderAround Weight:=xlThin
.Borders(xlInsideVertical).Weight = xlThin
End With
.Parent.Activate
End With
Application.ScreenUpdating = True
End Sub
klin89