Spreadsheet: 93225d1292842041-pivot-table-layout-match-calander
Sheet: Teams

Group A |  |  |  |  |  |  |  | Group B
Matches | Team A | Team B | Group | Date | Day | Venue | Time | Matches | Team A | Team B | Group | Date | Day | Venue | Time
1 | A1 | A2 | A | 2010-12-04 00:00:00 | 2010-12-04 00:00:00 | Park A | 1st Half | 1 | B1 | B2 | B | 2010-12-04 00:00:00 | 2010-12-04 00:00:00 | Park A | 2nd Half
2 | A1 | A3 | A | 2010-12-05 00:00:00 | 2010-12-05 00:00:00 | Park B | 1st Half | 2 | B1 | B3 | B | 2010-12-11 00:00:00 | 2010-12-11 00:00:00 | Park C | 1st Half
3 | A1 | A4 | A | 2010-12-05 00:00:00 | 2010-12-05 00:00:00 | Park B | 2nd Half | 3 | B1 | B4 | B | 2010-12-12 00:00:00 | 2010-12-12 00:00:00 | Park D | 1st Half
4 | A1 | A5 | A | 2010-12-11 00:00:00 | 2010-12-11 00:00:00 | Park C | 2nd Half | 4 | B1 | B5 | B | 2010-12-12 00:00:00 | 2010-12-12 00:00:00 | Park D | 2nd Half
5 | A1 | A6 | A | 2010-12-18 00:00:00 | 2010-12-18 00:00:00 | Park E | 1st Half | 5 | B1 | B6 | B | 2010-12-18 00:00:00 | 2010-12-18 00:00:00 | Park E | 2nd Half
6 | A1 | A7 | A | 2010-12-19 00:00:00 | 2010-12-19 00:00:00 | [NAME] | 1st Half | 6 | B1 | B7 | B | 2010-12-19 00:00:00 | 2010-12-19 00:00:00 | [NAME] | 2nd Half
7 | A1 | A8 | A | 2010-12-25 00:00:00 | 2010-12-25 00:00:00 | Park A | 1st Half | 7 | B1 | B8 | B | 2010-12-26 00:00:00 | 2010-12-26 00:00:00 | Park A | 2nd Half
8 | A2 | A3 | A | 2010-12-25 00:00:00 | 2010-12-25 00:00:00 | Park B | 2nd Half | 8 | B2 | B3 | B | 2010-12-26 00:00:00 | 2010-12-26 00:00:00 | Park B | 1st Half
9 | A2 | A4 | A | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | Park C | 2nd Half | 9 | B2 | B4 | B | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | Park C | 1st Half
10 | A2 | A5 | A | 2011-01-02 00:00:00 | 2011-01-02 00:00:00 | Park D | 1st Half | 10 | B2 | B5 | B | 2011-01-02 00:00:00 | 2011-01-02 00:00:00 | Park D | 2nd Half
11 | A2 | A6 | A | 2011-01-08 00:00:00 | 2011-01-08 00:00:00 | Park A | 2nd Half | 11 | B2 | B6 | B | 2011-01-09 00:00:00 | 2011-01-09 00:00:00 | Park E | 1st Half
12 | A2 | A7 | A | 2111-01-08 00:00:00 | 2111-01-08 00:00:00 | Park B | 1st Half | 12 | B2 | B7 | B | 2011-01-09 00:00:00 | 2011-01-09 00:00:00 | Park E | 2nd Half
13 | A2 | A8 | A | 2011-01-15 00:00:00 | 2011-01-15 00:00:00 | Park C | 1st Half | 13 | B2 | B8 | B | 2011-01-15 00:00:00 | 2011-01-15 00:00:00 | Park C | 2nd Half
14 | A3 | A4 | A | 2011-01-16 00:00:00 | 2011-01-16 00:00:00 | [NAME] | 2nd Half | 14 | B3 | B4 | B | 2011-01-16 00:00:00 | 2011-01-16 00:00:00 | Park B | 2nd Half
15 | A3 | A5 | A | 2011-01-22 00:00:00 | 2011-01-22 00:00:00 | Park A | 2nd Half | 15 | B3 | B5 | B | 2011-01-22 00:00:00 | 2011-01-22 00:00:00 | Park D | 2nd Half
16 | A3 | A6 | A | 2011-01-22 00:00:00 | 2011-01-22 00:00:00 | Park C | 1st Half | 16 | B3 | B6 | B | 2011-01-22 00:00:00 | 2011-01-22 00:00:00 | Park A | 1st Half
17 | A3 | A7 | A | 2011-01-23 00:00:00 | 2011-01-23 00:00:00 | Park B | 1st Half | 17 | B3 | B7 | B | 2011-01-23 00:00:00 | 2011-01-23 00:00:00 | Park C | 1st Half
18 | A3 | A8 | A | 2011-01-23 00:00:00 | 2011-01-23 00:00:00 | [NAME] | 1st Half | 18 | B3 | B8 | B | 2011-01-23 00:00:00 | 2011-01-23 00:00:00 | Park D | 2nd Half
19 | A4 | A5 | A | 2011-01-29 00:00:00 | 2011-01-29 00:00:00 | Park A | 2nd Half | 19 | B4 | B5 | B | 2011-01-30 00:00:00 | 2011-01-30 00:00:00 | ParkE | 1st Half
20 | A4 | A6 | A | 2011-01-29 00:00:00 | 2011-01-29 00:00:00 | Park D | 1st Half | 20 | B4 | B6 | B | 2011-01-30 00:00:00 | 2011-01-30 00:00:00 | Park C | 1st Half
21 | A4 | A7 | A | 2011-01-29 00:00:00 | 2011-01-29 00:00:00 | Park B | 2nd Half | 21 | B4 | B7 | B | 2011-01-30 00:00:00 | 2011-01-30 00:00:00 | Park B | 1st Half
22 | A4 | A8 | A | 2011-02-05 00:00:00 | 2011-02-05 00:00:00 | Park A | 2nd Half | 22 | B4 | B8 | B | 2011-02-05 00:00:00 | 2011-02-05 00:00:00 | Park A | 1st Half
23 | A5 | A6 | A | 2011-02-06 00:00:00 | 2011-02-06 00:00:00 | Park B | 2nd Half | 23 | B5 | B6 | B | 2011-02-05 00:00:00 | 2011-02-05 00:00:00 | Park E | 2nd Half
24 | A5 | A7 | A | 2011-02-06 00:00:00 | 2011-02-06 00:00:00 | [NAME] | 2nd Half | 24 | B5 | B7 | B | 2011-02-05 00:00:00 | 2011-02-05 00:00:00 | [NAME] | 1st Half
25 | A5 | A8 | A | 2011-02-06 00:00:00 | 2011-02-06 00:00:00 | Parf F | 1st Half | 25 | B5 | B8 | B | 2011-02-06 00:00:00 | 2011-02-06 00:00:00 | Park B | 2nd Half
26 | A6 | A7 | A | 2011-02-12 00:00:00 | 2011-02-12 00:00:00 | Park D | 2nd Half | 26 | B6 | B7 | B | 2011-02-12 00:00:00 | 2011-02-12 00:00:00 | Park D | 1st Half
27 | A6 | A8 | A | 2011-02-12 00:00:00 | 2011-02-12 00:00:00 | Park E | 1st Half | 27 | B6 | B8 | B | 2011-02-13 00:00:00 | 2011-02-13 00:00:00 | Park A | 2nd Half
28 | A7 | A8 | A | 2011-02-13 00:00:00 | 2011-02-13 00:00:00 | Park B | 2nd Half | 28 | B7 | B8 | B | 2011-02-13 00:00:00 | 2011-02-13 00:00:00 | [NAME] | 1st Half
Notes
There Could be Max of 28 Matches of Each Group and total of 56 Matches (pre determined) however group wise number of matches may vary based on no of teams
Requirement
1 | Based on the above table I want to automatically fill in a Sheet!Schedule in the layout mentioned in Sheet!Schedule.
2 | However, for the ease of Calculation any suggestion to change column formation may also be advised along with the formula.
3 | Assign Match numbers according to dates and total number of matches