Create a new column based on another column

Hi non23, check this:

Output

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjU0NDIw0NMzNbS0MDCwNrW0NANzLUFcpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Value = _t]),
    Ad_NewColumn = Table.AddColumn(Source, "New Column", each 
        [ a = Text.Split([Value], ";"),
          b = List.Transform(a, (x)=> Text.Split(x, "..")),
          c = List.Transform(b, (x)=>  List.Generate( ()=> Number.From(x{0}), each _ <= Number.From(x{1}), each _ +100 ) ),
          d = List.Combine(c)
        ][d]),
    ExpandedNewColumn = Table.ExpandListColumn(Ad_NewColumn, "New Column")
in
    ExpandedNewColumn