let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"COMPANY", type text}, {"GOLFER 1", type text}, {"GOLFER 1 CELL PHONE", type any}, {"GOLFER 1 EMAIL", type any}, {"GOLFER 2", type text}, {"GOLFER 2 CELL PHONE", type any}, {"GOLFER 2 EMAIL", type any}, {"GOLFER 3", type text}, {"GOLFER 3 CELL PHONE", type any}, {"GOLFER 3 EMAIL", type any}, {"GOLFER 4", type text}, {"GOLFER 4 CELL PHONE", type any}, {"GOLFER 4 EMAIL", type any}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"COMPANY"}, "Attribute", "Value")
in
#"Unpivoted Other Columns"