I have amended the enclosed workbook. The pivot table is there but i'm unable to set the layout in a way that matches appear for respective dates as
Sheet: Teams2 contain the details of matches.
Sheet: Schedule contains pivot table (output)
All i want is that for each date and venue and time slot teams of respective match appears in a format as follow:
On 4th Dec there are 2 matches (as shown in schedule layout)
but i want teams for a match to be appeared as A1 Vs. A2......
and B1 Vs. B2.....
Kindly advice
Bookmarks