Hi,
I've got a slightly random question that I think that there may be an obvious answer to:
I have a horizontal list of teams (as part of a HLOOKUP with team names on one row and a rating on another). The teams (64) are listed horizontally from A2 to BL2.
I have set them to play out a tournament and have generated a data table to generate results.
In short, can I list the teams in A2-BL2, vertically in G67-G130 (so I can set up a log of the data table results to generate winning percentages). With my data table set up vertically and given the number of teams it would just be easier to do this vertically for printing off, rather than doing it horizontally (e.g. you could see a significant numbers of row vertically but only 6 or so columns horizontally - if that makes sense).
I know I could re-type everything from A2-BL2 into G67-G130 (e.g. directly copy A2 to G67) - but I just wondered if there was a more elegant (and quicker) way of doing this.
Thanks for any advice offered.
Bookmarks