Convert table that is using #lf (line feed)

Some similarity with DataNinja777 's but split/zip/convert to table in one line.

See attached Excel workbook.

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    // Keep note of original column headers and their order:
    ColmHdrs = Table.ColumnNames(Source),
    AddedCustom = Table.AddColumn(Source, "Custom", each Table.FromRows(List.Zip({Text.Split([Unit], "#(lf)"),Text.Split([qty], "#(lf)"),Text.Split([Year], "#(lf)")}),{"Unit","qty","Year"})),
    RemovedColumns = Table.RemoveColumns(AddedCustom,{"Unit", "qty", "Year"}),
    ExpandedCustom = Table.ExpandTableColumn(RemovedColumns, "Custom", {"Unit", "qty", "Year"}, {"Unit", "qty", "Year"}),
    // use the original column order from th ColmHdrs step:
    ReorderedColumns = Table.ReorderColumns(ExpandedCustom,ColmHdrs)
in
    ReorderedColumns

You can add a step like:

ReplacedValue = Table.ReplaceValue(ExpandedCustom,each [qty],each try Number.From([qty]) otherwise [qty] ,Replacer.ReplaceValue,{"qty"})

This leaves the column as type Any but the individual values will be type number or type text depending on content, and so they'll appear in Excel as numbers/text in cells (justified right if numbers and justified left if text).

For Year you could do something similar. They could be combined in a single step but that would require (I think) an inline function but I've been lazy.