EXAMPLE PIVOT TO LIST.pngEXAMPLE PIVOT TO LIST.png
Hello Everyone,
In the example at the excel, how by pivot can I create a table
where for each pupil I can see a list of the subjects he has taken?
Like in the example at the excel: Bob took Math, Literature,History and so on for all the other pupils.
A pivot table can't do that, and your version of Excel doesn't have the functions that make it easy to do.
Just apply filters to your table - then you can filter for one or more students and see the classes they have taken, or filter for a particular subject and see what students are taking that subject.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks