Since there are multiple Faculties for same session for a single course, you have to include Date in the query. Because the sessions belongs to different dates.
Use the following query.
TRANSFORM First(Tb_SCh_TIme_Table.Faculty_Code) AS a
SELECT Tb_SCh_TIme_Table.Date, Tb_SCh_TIme_Table.Course
FROM Tb_SCh_TIme_Table
GROUP BY Tb_SCh_TIme_Table.Date, Tb_SCh_TIme_Table.Course
PIVOT Tb_SCh_TIme_Table.Session;