let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"NAME", type text}, {"BIO", Int64.Type}, {"MF", Int64.Type}, {"KIM", Int64.Type}, {"MAT", Int64.Type}, {"FIZ", Int64.Type}, {"FIZ2", Int64.Type}, {"MAT3", Int64.Type}, {"TM", Int64.Type}, {"GEO", Int64.Type}, {"TAR", Int64.Type}, {"COG", Int64.Type}, {"TUR", Int64.Type}, {"FEL", Int64.Type}, {"EDE", Int64.Type}}),
#"Transposed Table" = Table.Transpose(#"Changed Type"),
#"Filtered Rows" = Table.SelectRows(#"Transposed Table", each ([Column1] = 1)),
#"Added Index" = Table.AddIndexColumn(#"Filtered Rows", "Index", 0, 1, Int64.Type),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Added Index", {"Index"}, "Attribute", "Value"),
#"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Index", "Attribute"})
in
#"Removed Columns"
Bookmarks