动态合并列，除了所述的列

发布于 2025-02-13 11:40:54 字数 1232 浏览 0 评论 0原文

我的功能如图所示，可以合并所有列。

M代码：

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    MergeAllColumns = Table.AddColumn(Source, "Merged", each 
            let 
            CreateList = Record.ToList(_),
            ConvertToText = List.Transform(CreateList, each Text.From(_)), 
            Concatenate = Text.Combine( ConvertToText, " ")
            in 

            Concatenate
    
     ),
    #"Removed Other Columns" = Table.SelectColumns(MergeAllColumns,{"Merged"})
in
    #"Removed Other Columns"

我希望修改此代码，以便我可以说“合并其他细胞”。在这种情况下，这只是我可以独自留下的第一列，但理想情况下，我希望能够说明哪些列应保持不合格，然后无论有多少列，都将动态合并其中的所有内容。希望那是有道理的，谢谢。

Column1	Column2	Column3	Column4	Column5	Column6	Column6
第7列1	您好，	好吗	，	您	Harry
Person 2	您好，	我	很好	，	谢谢	您

原文

I have the function which merges all columns as shown.

M Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    MergeAllColumns = Table.AddColumn(Source, "Merged", each 
            let 
            CreateList = Record.ToList(_),
            ConvertToText = List.Transform(CreateList, each Text.From(_)), 
            Concatenate = Text.Combine( ConvertToText, " ")
            in 

            Concatenate
    
     ),
    #"Removed Other Columns" = Table.SelectColumns(MergeAllColumns,{"Merged"})
in
    #"Removed Other Columns"

I wish to modify this code so that, I can say essentially say "Merge Other Cells". In this case, it's just column one which I can leave alone but ideally, I would like to be able to state which columns should remain unmerged and then everything not included in that will be dynamically merged no matter how many columns there are. Hope that makes sense, thanks.

Column1	Column2	Column3	Column4	Column5	Column6	Column7
Person 1	Hello	How	Are	You	Harry
Person 2	Hello	I	Am	Well	Thank	you

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

夕色琉璃 2025-02-20 11:40:55

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Added Index" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
Exclude={"Column1", "Column3"},
List=List.Difference(Table.ColumnNames(Source),Exclude),
MergeAllColumns= Table.AddColumn(#"Added Index","Custom", each Text.Combine(Record.ToList( Table.SelectColumns(#"Added Index",List){[Index]}), " ")),
#"Removed Columns" = Table.RemoveColumns(MergeAllColumns, List.Combine({{"Index"}, List}))
in #"Removed Columns"

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Added Index" = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
Exclude={"Column1", "Column3"},
List=List.Difference(Table.ColumnNames(Source),Exclude),
MergeAllColumns= Table.AddColumn(#"Added Index","Custom", each Text.Combine(Record.ToList( Table.SelectColumns(#"Added Index",List){[Index]}), " ")),
#"Removed Columns" = Table.RemoveColumns(MergeAllColumns, List.Combine({{"Index"}, List}))
in #"Removed Columns"

回复收藏 0 原文

~没有更多了~