Spreadsheet: 835115d1688312904-copy-cell-which-starts-with-a-number-to-another-cell-data_form
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | HOME & AWAY TABLE
Year | Date | Time | Competition | Home Team (HMT) | [NAME] ([NAME]) | Half Time Result | Full Time Result | Time of Goals | HMT Red Card | AWT Red Card | HMT ODDS | Draw ODDS | [NAME] | HMT Ladder/Table Position | AWT Ladder/Table Position | HMT Table Win Draw Loss @Home |  |  | HMT Goals For Against @Home |  | HMT Form Win Draw Loss @Away |  |  | HMT Goals For Against @Away |  | AWT Form Win Draw Loss @Home |  |  | [NAME] @Home |  | AWT Form Win Draw Loss @Away |  |  | [NAME] @Away
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: This information below is the Home & Away "table" before the start of the round.
20 21 | 2021-07-02 00:00:00 | 16:30:00 | England Premier League | Liverpool | Manchester City | 0-0 | 1-4 | [NAME]    HMT (pen)63' [NAME]    AWT 76'    AWT 83' | 55'       65' | 90' | 3.35 | 3.75 | 2.08 | 4 | 1 | 7 | 2 | 2 | 21 | 10 | 4 | 5 | 2 | 22 | 15 | 8 | 2 | 1 | 22 | 7 | 6 | 3 | 1 | 17 | 6
All the below information is required on the same row for all matches. Note that from column ‘O’ and onwards is the Home & Away ‘table’ information. I will describe in detail all the columns from above. A. The year or season the match was played, i.e. 2009/2010 B. The date the match was played. C. The time the match was played. D. The competition, i.e. England premier league. You can use abbreviation, i.e. EPL etc. E. The name of the home team. F. The name of the away team. G. The result of the match at half time. H. The result of the match at fulltime. I. The time of each goal in the match that the home team scored and the away team scored. Note that this can be split into different columns if it is easier for you. J. The time in the match where the home team received a red card. Note that this can be split into different columns if it is easier for you. K. The time in the match where the away team received a red card. Note that this can be split into different columns if it is easier for you. L. The odds of the home team to win the match. M. The odds for a draw in the match. N. The odds for the away team to win the match. TABLE INFORMATION O. The position on the table for the home team, i.e. in the example above, Liverpool is running 4th in the competition. P. The position on the table for the away team, i.e. in the example above, Manchester City is running 1st in the competition. Q. The number of wins at home for the HOME team. R. The number of draws at home for the HOME team. S. The number of losses at home for the HOME team. T. The number of goals the HOME team has scored at home. U. The number of goals the HOME team has conceded at home. V. The number of wins away from home for the HOME team. W. The number of draws away from home for the HOME team. X. The number of losses away from home for the HOME team. Y. The number of goals the HOME team has scored away from home. Z. The number of goals the HOME team has conceded away from home. AA. The number of wins at home for the AWAY team. AB. The number of draws at home for the AWAY team. AC. The number of losses at home for the AWAY team. AD. The number of goals the AWAY team has scored at home. AE. The number of goals the AWAY team has conceded at home. AF. The number of wins away from home for the AWAY team. AG. The number of draws away from home for the AWAY team. AH. The number of losses away from home for the AWAY team. AI. The number of goals the AWAY team has scored away from home. AJ. The number of goals the AWAY team has conceded away from home.