Bonjour,
Un exemple dans le fichier joint.
Cdlt.
Public Sub DEMO()
Dim tbl, x, y
Dim Arr() As String
Dim v As String
Dim I As Long, _
J As Long, _
k As Long
With ActiveSheet
.Cells(5).CurrentRegion.Offset(1, 0).ClearContents
tbl = .Cells(1).CurrentRegion.Value
ReDim Arr(1 To UBound(tbl) - 1)
k = 1
For I = 2 To UBound(tbl, 1)
x = Split(tbl(I, 1), Chr(10))
y = Split(tbl(I, 2), Chr(10))
For J = 0 To UBound(x)
v = v & x(J) & y(J) & Chr(10)
Next J
Arr(k) = Left(v, Len(v) - 1)
v = ""
k = k + 1
Next I
.Cells(2, 5).Resize(UBound(Arr)) = Application.Transpose(Arr)
End With
Erase Arr
End Sub