Please have a look at the attached data.
The data is presented in a table which finishes at row 1239.
I have then created another table from row 1242 showing how I want the data to be displayed for each member. For each member I want their data presented according to the format i have displayed. I have done the first one for you reference. I would want to use the spreadsheet in future so if the data changes then the table can be updated. I require this asap with the next 5-6 hours.