I am trying to generate a league schedule. I have drawn a chart of all matches which will by played but i am unable to convert that chart into columns. Kindly give a formula that will convert that charge into columns. The chart is attached with this message.
The team names are displayed in first row and first column. When the intersection of these is "H" the team name in column is to be displayed in home team column, when intersection is "A" the team name in first column is displayed in away team column.
Your help is required.