Bonjour,
Une autre version Power Query.
let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
SplitData = Table.AddColumn(Source, "Data", each Table.FromColumns({Text.Split([Colonne1],"#(lf)"),Text.Split([Colonne2],"#(lf)")})),
Expand = Table.ExpandTableColumn(Table.SelectColumns(SplitData,{"Data"}), "Data", {"Column1", "Column2"}, {"Column1", "Column2"})
in
Expand
A+