Bonjour,
voici une adaptation du code
Sub aargh()
With Sheets("données")
dl = .Cells(Rows.Count, 2).End(xlUp).Row
Set ws = Sheets("résultat")
k = 2
For i = 3 To dl
j = 2
While .Cells(i, j) <> ""
k = k + 1
ws.Cells(k, 2).Resize(, 7).Value = .Cells(i, j).Resize(, 7).Value
j = j + 7
Wend
Next i
ws.Cells(3, 2).Resize(k, 7).Replace "xx", "", lookat:=xlWhole
End With
End Sub