Splitting a row with multiple lines of text to different rows

Eizenman 

One more variant with Power Query. Not everything from user interface, the script is

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    UnpivotColumns = Table.UnpivotOtherColumns(
        Source,
        {},
        "Attribute", "Value"
    ),
    DateToText = Table.ReplaceValue(
        UnpivotColumns,
        each [Value],
        each
            if Type.Is(Value.Type([Value]),DateTime.Type)
            then Date.ToText(DateTime.Date([Value]),"yyyy-MM-dd")
            else [Value],
        Replacer.ReplaceValue,{"Value"}
    ),
    AllToText = Table.TransformColumnTypes(
        DateToText,
        {{"Value", type text}}
    ),
    TransformColumn = Table.TransformColumns(
        AllToText,
        {
            {"Value", Splitter.SplitTextByDelimiter("#(lf)")}
        }
    ),
    ExpandToRows = Table.ExpandListColumn(
        TransformColumn,
        "Value"
    ),
    GroupRows = Table.Group(
        ExpandToRows,
        {"Attribute"},
        {{"Group", each [Value]}}
    ),
    Result = Table.FromRows(
        List.Zip(GroupRows[Group]),
        GroupRows[Attribute]
    ),
    ProperType = Table.TransformColumnTypes(
        Result,
        {
            {"Line", Int64.Type},
            {"Date", type date},
            {"Supplier", type text}
        }
    )
in
    ProperType