Paste_Image.png
Paste_Image.png
let
源 = Excel.CurrentWorkbook(){[Name="表2"]}[Content],
轉(zhuǎn)置表 = Table.Transpose(源),
提升的標(biāo)題 = Table.PromoteHeaders(轉(zhuǎn)置表),
篩選的行 = Table.SelectRows(提升的標(biāo)題, each ([型號(hào)] <> "型號(hào)")),
逆透視的其他列1 = Table.UnpivotOtherColumns(篩選的行, {"編號(hào)", "規(guī)格", "型號(hào)"}, "屬性", "值"),
刪除的列 = Table.RemoveColumns(逆透視的其他列1,{"編號(hào)", "屬性"})
in
刪除的列
