Replace Values in List

[JackDanIce]

Hi,

I have a list of letters (strings) and I'd like to add a post-fix " Class Rating" to, e.g.

Before List = {"A", "B", "C"}

After List = {"A Class Rating", "B Class Rating", "C Class Rating"}

This doesn't work:

= List.ReplaceValue(ClassRating, each _ , & " Class Rating",Replacer.ReplaceText)

Unsure of syntax, can anyone suggest?

TIA,
Jack

 

[smozgur]

Try List.Transform:

let
    Source = {"A", "B", "C"},
    Result = List.Transform(Source, each _ & " Class Rating")
in
    Result

 

[JackDanIce]

Hi @smozgur yes this related to other post for combining values into single columns (dynamic column count) but good as a separate answer as I can see how to use this in other ways.

Thank you!

 

[smozgur]

Glad to hear it helps.