一列拆分成两列（BT拆）（Power Query）-526互联

问题：左表转成右表

let
    源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    分组的行 = Table.Group(源, {"机房名称", "网络制式"}, {"合并", each Text.Combine([BBU名称],",")}),
    按分隔符拆分列 = Table.SplitColumn(分组的行, "合并", Splitter.SplitTextByDelimiter(","), {"合并.1", "合并.2", "合并.3", "合并.4", "合并.5"}),
    分组转置删行提升 = Table.Group(按分隔符拆分列, {"机房名称"}, {"合并", each Table.PromoteHeaders(Table.Skip(Table.Transpose(_),1))}),
    展开 = Table.ExpandTableColumn(分组转置删行提升, "合并", {"4G", "5G"})
in
    展开

Power

Query