问题：C列相同的，GH两列的内容横向排成一行
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
合并的列 = Table.CombineColumns(源,{"标题7", "标题8"},Combiner.CombineTextByDelimiter(":"),"已合并"),
分组的行 = Table.Group(合并的列, {"标题3"}, {"合并", each Text.Combine([已合并],":")}),
按分隔符拆分列 = Table.SplitColumn(分组的行, "合并", Splitter.SplitTextByDelimiter(":", QuoteStyle.Csv), {"合并.1", "合并.2", "合并.3", "合并.4", "合并.5", "合并.6", "合并.7", "合并.8"})
in
按分隔符拆分列标签：Power,分隔符,合并,一行,标题,Table,Query From： https://www.cnblogs.com/officeplayer/p/17323725.html