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 for teams when they are home, or another one when they are away, but not both.
Any ideas how to get the pivot table to not care if they are home or away?
<tbody>
</tbody>
Any ideas how to get the pivot table to not care if they are home or away?
| Date | Away | Aw.line | Home | Hm.line | O/U | Aw.score | Hm.score |
| 9/8/2016 | Carolina | -3 | Denver | 3 | 40.5 | 20 | 21 |
| 9/11/2016 | Cleveland | 4 | Philadelphia | -4 | 41.5 | 10 | 29 |
| 9/11/2016 | Detroit | 2.5 | Indianapolis | -2.5 | 51 | 39 | 35 |
| 9/11/2016 | Minnesota | -2.5 | Tennessee | 2.5 | 40 | 25 | 16 |
| 9/11/2016 | San Diego | 6.5 | Kansas City | -6.5 | 45.5 | 27 | 33 |
<tbody>
</tbody>
Last edited by a moderator:
