table contents.pngI have three columns and values as given below
Date Team 1 Team 2
3-Apr C B
4-Apr G E
5-Apr I F
6-Apr B H
6-Apr A E
7-Apr F D
7-Apr I G
8-Apr H C
9-Apr E B
10-Apr D A
How can convert this timetable in crossover table as given below. Is there any function/process in Excel 2010 to create such matrix automatically?
A B C D E F G H
A 6-Apr
B 6-Apr
C 3-Apr
D 10-Apr
E 9-Apr
F 7-Apr
G 4-Apr
H 8-Apr
I 5-Apr 7-Apr .
Please see the attached screenshot for exact table contents.
Thank you for your help.
Bookmarks