Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rearranging data
I've been set a fairly big project at work and I need to rearrange the
data in an excel sheet. I'll try and explain it as simply as possible. example format at the moment: Name course result Brian geog A Brian maths B Brian phys C Brian Sport C Tom maths B Tom geog A There are roughly 5000 rows with 300 seperate names. format required: Name geog maths phys Brian A B C Tom A A Each student doesnt do the same amount of courses, so there will be blanks (like tom doing phys in example). To make my life even more difficult there is lots of data in the source file I have that doesnt need to be entered onto the final sheet (like brian's sports result in example). at the moment I have the source file sorted alphabetically. What's the best approach to solving this? Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging Data Within a Cell | Excel Worksheet Functions | |||
Rearranging and Merging | Excel Discussion (Misc queries) | |||
Rearranging Data in Excel | Excel Discussion (Misc queries) | |||
Rearranging the layout of data | Excel Discussion (Misc queries) | |||
Rearranging Data Help... | Excel Discussion (Misc queries) |