My friends know me as someone who is good at excel, and therefore, I am more than happy to help them with any project they need help with - it is what we all would do.
I got given a chart which was manually inputted and asked to make it automated vertical big board (all positions, VBB for short) and horizontal big board (all positions have separate rankings, HBB for short).
I decided that the easiest approach to this would be to start from scratch with an input sheet and two output sheets (one for each style of board). Both big boards are automated, meaning that the only thing that needs to happen after you input the data is for him to sort the VBB by his choice of column and it is good to go.
If anyone would like to have a look at the sheet, the link is: