[B][COLOR="DarkSlateGray"]Sub toto()
Dim i&, j&, n&, tmp, oDat, sDat()
With Sheets("Feuil1")
oDat = .Range(.Cells(1, 1), .Cells(1, 1).End(xlDown)).Value
End With
For i = 1 To UBound(oDat, 1)
tmp = Split(vbLf & oDat(i, 1), vbLf)
For j = 1 To UBound(tmp)
n = n + 1
ReDim Preserve sDat(1 To 1, 1 To n)
sDat(1, n) = tmp(j)
Next j
Next i
With Sheets("Feuil2")
.Range(.Cells(1, 1), .Cells(UBound(sDat, 2), 1)) = WorksheetFunction.Transpose(sDat)
End With
End Sub[/COLOR][/B]