Excel Data transformation requires ASAP

Excel Data transformation requires ASAP


Job Description

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.

Open Attachment