Board Thread:Game Discussion/@comment-31943809-20180601155628/@comment-27006659-20180601162142

Here's the query settings I'm using.

let Source = Web.Page(Web.Contents("http://rr3.wikia.com/wiki/RR3_Wiki:All_Series")), Data1 = Source{1}[Data], #"Promoted Headers" = Table.PromoteHeaders(Data1, [PromoteAllScalars=true]), #"Added Index" = Table.AddIndexColumn(#"Promoted Headers", "Index", 1, 1), #"Reordered Columns" = Table.ReorderColumns(#"Added Index",{"Index", "Event", "Grp", "Series", "Type", "Location", "Race#(cr)#(lf)Info", "Roll#(cr)#(lf)St.", "Day", "Laps", "PR", "R$", "Fame"}), #"Removed Columns" = Table.RemoveColumns(#"Reordered Columns",{"Roll#(cr)#(lf)St.", "Day"}), #"Reordered Columns1" = Table.ReorderColumns(#"Removed Columns",{"Index", "Event", "Grp", "Type", "Location", "Race#(cr)#(lf)Info", "Laps", "PR", "R$", "Fame", "Series"}), #"Removed Columns1" = Table.RemoveColumns(#"Reordered Columns1",{"Grp"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"Index", "Index.1"}, {"Event", "Index"}, {"Type", "Event"}}), #"Replaced Value" = Table.ReplaceValue(#"Renamed Columns","Dif","",Replacer.ReplaceText,{"Laps"}), #"Changed Type" = Table.TransformColumnTypes(#"Replaced Value",{{"Laps", type number}, {"PR", type number}, {"R$", type number}, {"Fame", type number}}), #"Renamed Columns1" = Table.RenameColumns(#"Changed Type",) in #"Renamed Columns1"