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

颓废的飞鱼 · 2020-9-25 03:15:19

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

zhangzq · 2020-9-25 03:21:19

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

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

复制代码

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

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

复制代码

10347101820265.zip (60.74 KB, 下载次数: 0)

hanny · 2020-9-25 03:28:19

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
  重排序的列

10347101820266.rar (78.67 KB, 下载次数: 0)