I have sports statistical data and both the home and away team are listed on the same line. I am trying to create a way to do a pivot table that would allow me to look at a teams statistics whether they played at home or not. The way the sheet is structured, I can do a heck of a pivot table...