Power Query技术问询：用分号合并多行文本报错，求正确实现方法

错误原因 #

你遇到的Expression.Error: We cannot convert the value ";" to type Function错误，是因为Table.CombineColumns的第三个参数要求传入合并函数，而非直接的分隔符字符串。直接传入";"不符合该参数的类型要求。

修正后的完整代码 #

let
    Source = #"New Project List",
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Project"}),
    #"Cleaned Text" = Table.TransformColumns(#"Removed Other Columns",{{"Project", Text.Clean, type text}}),
    #"Trimmed Text" = Table.TransformColumns(#"Cleaned Text",{{"Project", Text.Trim, type text}}),
    #"Sorted Rows" = Table.Sort(#"Trimmed Text",{{"Project", Order.Ascending}}),
    #"Removed Duplicates" = Table.Distinct(#"Sorted Rows"),
    #"Combined Text" = Table.CombineColumns(#"Removed Duplicates", {"Project"}, (columns) => Text.Combine(columns, ";"), "Combined")
in
    #"Combined Text"

关键修改说明 #

将原代码中合并列的行：

#"Combined Text" = Table.CombineColumns(#"Removed Duplicates", {"Project"}, ";", "Combined")

替换为：

#"Combined Text" = Table.CombineColumns(#"Removed Duplicates", {"Project"}, (columns) => Text.Combine(columns, ";"), "Combined")

这里通过匿名函数(columns) => Text.Combine(columns, ";")，将分号作为分隔符传递给Text.Combine函数，满足Table.CombineColumns对第三个参数的函数类型要求，实现多行文本按分号合并到单个单元格的需求。

内容的提问来源于stack exchange，提问作者Amanda barrow-scott