PowerQuery练习小案例

Paste_Image.png Paste_Image.png

let
    源 = Excel.CurrentWorkbook(){[Name="表2"]}[Content],
    转置表 = Table.Transpose(源),
    提升的标题 = Table.PromoteHeaders(转置表),
    筛选的行 = Table.SelectRows(提升的标题, each ([型号] <> "型号")),
    逆透视的其他列1 = Table.UnpivotOtherColumns(筛选的行, {"编号", "规格", "型号"}, "属性", "值"),
    删除的列 = Table.RemoveColumns(逆透视的其他列1,{"编号", "属性"})
in
    删除的列