Data left to right

Hello netanel 

 

you can transform you column (you could basically also add a custom column, but that would only make more unneccessary data) and apply the function in my code

    Reverse = Table.TransformColumns
    (
        #"Changed Type",
        {
            {
                "YourColumn",
                each Text.Combine(List.Reverse(Text.ToList(_))), 
                type text
            }
        }
    )

if you need more columns to be transformed, you have to add a another nested list. In case I can show you that too. Here a complete code example to see how it works

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckxKVkhJTbNXitWJVvLPSFSoSElUio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [YourColumn = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"YourColumn", type text}}),
    Reverse = Table.TransformColumns
    (
        #"Changed Type",
        {
            {
                "YourColumn",
                each Text.Combine(List.Reverse(Text.ToList(_))), 
                type text
            }
        }
    )
in
    Reverse

transforms this

 

into this

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy