Valued service providers.
I request some help in transposing a single column of players to 3 (or 4) columns based on the score (rank) of the individual players, refer the attached example.
Columns B and C list a number of players and their scores. They need to be transposed to columns F, G and H based on their rank and in the cell order shown. If there are an odd number of players the 1st group may end up as a single or 2 man group shown in the example.
To add flexibility, the number of players could be up to 150 and the groups could be 3 or 4 man groups.
I suspect this can be easily solved with a macro, which unfortunately I am not familiar with.
Thanking you in advance.
Bookmarks