Want to see only Mr. Smith's timetable for the week? =FILTER(ASC_Table, ASC_Table[Teacher]="Mr. Smith", "No classes") Because you’re using Excel 2021, the result will automatically spill into the adjacent cells—no Ctrl+Shift+Enter required.
In aSc, go to > Teachers (or Students/Subjects). Select the rows you need and use Ctrl+C . Paste directly into Excel 2021.