I have a dataset from the web where the data is structured as this
now i'd like to have an added column where the line is calculated for each team, and the totals seperated for further calculations
a column where Evansville has -17 as Open and -22 as close and the corresponding line for Louisville. Is there an Excel formula to transform this to easier structured data?
Rot | VH | Team | 1st | 2nd | Final | Open | Close | ML | 2H |
717 | V | Evansville | 27 | 20 | 47 | 135,5 | 141 | 2500 | 74,5 |
718 | H | Louisville | 43 | 35 | 78 | 17 | 22,5 | -5000 | 8,5 |
a column where Evansville has -17 as Open and -22 as close and the corresponding line for Louisville. Is there an Excel formula to transform this to easier structured data?