Bonsoir,
Sub Dooz()
Dim wsO2 As Worksheet, s%, n%, k%, kk%, ss%, Lst
Set wsO2 = Worksheets("Onglet 2")
With Worksheets("Onglet 1")
For s = 1 To 52
n = .Cells(s + 3, .Columns.Count).End(xlToLeft).Column
If n > 4 Then
For k = 5 To n
If .Cells(s + 3, k) <> "" Then
Lst = Split(Replace(.Cells(s + 3, k), Chr(34), ""), ",")
ss = s * 3 + 1: kk = (k - 5) * 11 + 7
wsO2.Cells(kk, ss).Resize(UBound(Lst) + 1) = _
WorksheetFunction.Transpose(Lst)
End If
Next k
End If
Next s
End With
End Sub
Appuyer sur le bouton pour tester (après activation des macros).
Cordialement.