let
Source = List.Generate(()=> 10, each _ < 110, each _ + 1),
ToTable = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
Split = Table.SplitColumn(Table.TransformColumnTypes(ToTable, {{"Column1", type text}}, "en-US"),"Column1",Splitter.SplitTextByPositions({0, 1}, true),{"Column1", "Column2"}),
ChangedType = Table.TransformColumnTypes(Split,{{"Column1", Int64.Type}, {"Column2", Int64.Type}}),
ReplaceValue = Table.ReplaceValue(ChangedType,0,10,Replacer.ReplaceValue,{"Column2"}),
SortRows = Table.Sort(ReplaceValue,{{"Column1", Order.Ascending}, {"Column2", Order.Ascending}}),
AddColumn = Table.AddColumn(SortRows, "Mulitply", each [Column1]*[Column2]),
PivotedColumn = Table.Pivot(Table.TransformColumnTypes(AddColumn, {{"Column2", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(AddColumn, {{"Column2", type text}}, "en-US")[Column2]), "Column2", "Mulitply")
in
PivotedColumn