Excel Assesment Data

[danIT]

I have a large excel file of all of our Year 11 grades, Effort, Attainment, Grade etc for each subject x 15

 

E.g.

 

Admission Subject Effort Attainment Grade

0001 Maths 5 6 A

0001 English 7 6 B

 

Etc for 200 pupils and 15 subjects

 

I need to change the layout, i need subjects across the top of the sheet, admission stays where it is, but duplicates get removed,

 

Any ideaS?

[skunk]

You want to use pivot tables, these are a great way of condensing data and pivoting it as well.

 

They can take a bit to get used to, but once you have you will never look back.

 

Skunk

[elsiegee40]

This should help you:

 

http://www.microsoft.com/smallbusiness/resources/technology/business-software/how-to-use-pivottables-excels-data-tool-du-jour.aspx