So recently our college has shared a common timetable for all the classes, however, I want a timetable to be displayed only for the subjects that I has applied for. Can anyone help me with this? I am ready to share the timetable as well.
TIA!
So recently our college has shared a common timetable for all the classes, however, I want a timetable to be displayed only for the subjects that I has applied for. Can anyone help me with this? I am ready to share the timetable as well.
TIA!
Last edited by SyKick; 07-27-2020 at 11:22 AM.
Hello SyKick and Welcome to Excel Forum.
As you are using the 2019 version of Excel I would suggest using Get & Transform to unpivot the classes using the following Power Query advanced editor code:Note that the code also produces a 'Subject' column without the A1, B2 ... designations.Please Login or Register to view this content.
Once the row over row table is produced it may be referenced using a pivot table and the subjects for which you applied may be chosen using a slicer.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks