Merge multiple ReplaceValue steps

Hi LittleTimmy ,

There are 3 ways that you can have a try.

• All replace

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcitKLc5QcCwoyElVitWB8f2LEvPSkQUCUhOLwFz/kozUomKl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Fruit = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Fruit", type text}}),
    Custom1 = [#"Fresh Apple"= "Apple" ,  #"Fresh Orange" ="Orange", #"Fresh Pear" = "Pear"],
    #"Converted to Table" = Table.TransformColumns(#"Changed Type",{{"Fruit",each Record.FieldOrDefault(Custom1,_,_)}})
in
    #"Converted to Table"

• Split column

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcitKLc5QcCwoyElVitWB8f2LEvPSkQUCUhOLlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Fruit = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Fruit", type text}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Fruit", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Fruit.1", "Fruit.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Fruit.1", type text}, {"Fruit.2", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Fruit.1"})
in
    #"Removed Columns"

• create a conditional column

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcitKLc5QcCwoyElVitWB8f2LEvPSkQUCUhOLlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Fruit = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Fruit", type text}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [Fruit] = "Fresh Apple" then "Apple" else if [Fruit] = "Fresh Orange" then "Orange" else if [Fruit] = "Fresh Pear" then "Pear" else [Fruit]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Conditional Column",{"Fruit"})
in
    #"Removed Columns"