Table Transform add zero

[mduntley]

So I found a way yesterday to use table.Transform to add a leading zero if its not 4 digits, but I forgot how I did it

= #table({"Column 1"}, {{"740"},{"250"},{"0943"},{"420"},{"430"},{"440"},{"424"},{"0434"}})

 

[JGordon11]

let
    Source = #table({"Column 1"}, {{""},{"0"},{"1"},{"21"},{"420"},{"430"},{"440"},{"1424"},{"0434"}}),
    tbl = Table.TransformColumns(Source, {"Column 1", each Text.PadStart(_,4, "0")})
in
    tbl