let
Source = Table.Combine({
#"Master-Title", #
"Master-Content"}),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Unpivoted Only Selected Columns" = Table.Unpivot(#"Promoted Headers", {"Gear|All|CT", "Assembly|All|CT", "Housing|OP10|CT", "Worm|Wash|CT", "Worm|OP30|CT", "Worm|OP20|CT", "Worm|OP10|CT"}, "Attribute", "Value")
in
#"Unpivoted Only Selected Columns"
以上逆透视又没有可能只针对所有列名包含特定字符'CT'的列，这样子以后每次我加新的列也不会出错？