General Chat Thread, Excel Assesment Data in General; I have a large excel file of all of our Year 11 grades, Effort, Attainment, Grade etc for each subject ...
14th February 2008, 12:37 PM #1
Excel Assesment Data
I have a large excel file of all of our Year 11 grades, Effort, Attainment, Grade etc for each subject x 15
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,
IDG Tech News
14th February 2008, 03:08 PM #2
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.
14th February 2008, 03:14 PM #3
By NetworkGeezer in forum MIS Systems
Last Post: 16th February 2010, 10:22 PM
By Ben_Stanton in forum School ICT Policies
Last Post: 21st November 2007, 12:37 PM
By wesleyw in forum How do you do....it?
Last Post: 25th June 2007, 06:39 PM
By budgester in forum MIS Systems
Last Post: 26th February 2007, 11:45 AM
By ChrisH in forum Educational Software
Last Post: 6th December 2006, 03:02 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)