Text.Combine – รวมข้อความหลายรายการเป็นข้อความเดียว

= Text.Combine({"Hello", "World"})

= Text.Combine({"Seattle", "WA", "98001"}, ", ")

let
    Names = {"Doug", "J", "Elis"},
    FullName = Text.Combine(Names, " "),
    NamesWithNull = {"Rada", null, "Mihaylova"},
    FullNameWithNull = Text.Combine(NamesWithNull, " ")
in
    {FullName, FullNameWithNull}

let
    Source = Table.FromRecords({
        [First = "John", Last = "Smith", City = "NYC"],
        [First = "Jane", Last = "Doe", City = "LA"]
    }),
    FullInfo = Table.AddColumn(Source, "FullInfo", 
        each Text.Combine({[First], [Last], [City]}, " - "))
in
    FullInfo

= Text.Combine({"EMP", "2024", "001"}, "-")

let
    SourceTable = Table.FromRecords({
        [ID = 1, Tags = {"Power", "Query", "Excel"}],
        [ID = 2, Tags = {"M", "Language"}]
    }),
    CombinedTags = Table.AddColumn(SourceTable, "TagsText", 
        each Text.Combine([Tags], ", "))
in
    CombinedTags