bonjour,
voici le code adapté. La prochaine fois, merci de mettre un fichier, plutôt que des photos dont on ne peut rien faire.
Sub aargh()
With Sheets("sheet1") '<- à adapter
dl = .Cells(Rows.Count, 1).End(xlUp).Row
dl = dl - 1
t = .Cells(2, 1).Resize(dl, 2)
End With
With Sheets.Add
.Cells(1, 1).Resize(1, 3) = Split("col 1,col 2, col 3", ",")
lg = 1
For i = 1 To dl
el = Split(t(i, 2), "-")
For j = 0 To UBound(el) - 1
lg = lg + 1
.Cells(lg, 1) = t(i, 1)
.Cells(lg, 2) = t(i, 2)
.Cells(lg, 3) = el(j) & "-" & el(j + 1)
Next j
Next i
End With
End Sub