Paste the team into excel (from each team's page to prevent formatting issues) and run the following query:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type any}, {"Column7", type any}, {"Column8", type any}, {"Column9", type any}, {"Column10", type any}, {"Column11", type any}, {"Column12", type any}, {"Column13", type any}, {"Column14", type any}, {"Column15", type any}, {"Column16", type any}, {"Column17", type any}, {"Column18", type any}}),
#"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Column2"}),
#"Replaced Value" = Table.ReplaceValue(#"Removed Other Columns","No new player Notes","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","New Player Note","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Player Note","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","Day-to-Day","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","60-Day DL","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value5" = Table.ReplaceValue(#"Replaced Value4","10-Day DL","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value6" = Table.ReplaceValue(#"Replaced Value5","Not Active","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value7" = Table.ReplaceValue(#"Replaced Value6","(Empty)","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value8" = Table.ReplaceValue(#"Replaced Value7","Pitchers","",Replacer.ReplaceText,{"Column2"}),
#"Replaced Value9" = Table.ReplaceValue(#"Replaced Value8","","",Replacer.ReplaceText,{"Column2"}),
#"Removed Blank Rows" = Table.SelectRows(#"Replaced Value9", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
#"Removed Blank Rows"
Then just copy and paste