Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an extract from a student information system in Excel that
looks like this. Student Class Grade Quarter John Chemistry 70 1 John Chemistry 80 2 John Math 95 1 John Math 100 2 Alice Chemistry 67 1 Alice Chemistry 47 2 Alice Math 88 1 Alice Math 85 2 What I would like is this: John 70 80 95 100 Alice 67 47 88 85 However, since there are hundreds of students, this would be an extreme pain to do by hand. Is there any built-in formula or function in Excel that can do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining multiple rows with duplicate info -- help! | Excel Discussion (Misc queries) | |||
Combining duplicate rows into one | Excel Discussion (Misc queries) | |||
Combining data from column while deleting duplicate rows | Excel Programming | |||
combining duplicate rows | Excel Discussion (Misc queries) | |||
Combining duplicate records(rows) | Excel Worksheet Functions |