power query 中将一列中的数据分为两列

飘零雪

两行数据为同一组数据，原数据中给分了两行，在查询时希望将两行数据汇总到一行中

0星剑0

你要是全部合并的话就用这个还比较省事

1. = Table.FromRows(List.Transform(Table.Split(源,2),each [a=Table.ToRows(_),b=a{0}&a{1}][b]))

复制代码

这个也可以，简洁一点看的明白

1. = Table.FromRows(List.Transform(Table.Split(源,2),each List.Combine(Table.ToRows(_))))

复制代码

shijiexiansheng

let
    源 = Excel.CurrentWorkbook(){[Name="金相"]}[Content],
    索引 = Table.AddIndexColumn(源, "索引", 0),
    已添加自定义 = Table.AddColumn(索引, "自定义", each 索引{[索引]+1}[规格和型号]    ),
    筛选的行 = Table.SelectRows(已添加自定义, each not Text.Contains([规格和型号], "*")),
    合并的列 = Table.CombineColumns(筛选的行,{"规格和型号", "自定义"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"规格和型号"),
    重排序的列 = Table.ReorderColumns(合并的列,{"Source.Name", "日期", "炉号", "钢种", "规格和型号", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20", "Column21", "索引"})
in
    重排序的列