multiple row data in pivot

Try below:

DECLARE @cols AS NVARCHAR(MAX)
DECLARE @query AS NVARCHAR(MAX)

SELECT @cols = STUFF((SELECT ',' + QUOTENAME(StudentName)
                      FROM (
                        SELECT DISTINCT StudentName
                        FROM #finalTable
                        WHERE StudentID IN (SELECT value FROM string_split(@StudentID, ','))
                      ) AS tmp
                      FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')

SET @query = 'SELECT [BookId], BookTitle AS [Book], [ComboBookName], [CoreRPL], [Lexile], [NumberOfPages], [SessionPlanStatus], ' + @cols + '
              FROM (
                SELECT [BookID], BookTitle, [ComboBookName], [CoreRPL], [Lexile], [NumberOfPages], [SessionPlanStatus], StudentName, Status
                FROM #finaltable
                WHERE (('''+@BookID+''' = ''0'' OR [BookId] IN (' + CAST(@BookID AS VARCHAR(MAX)) + ')))
              ) x
              PIVOT (
                MAX(Status) FOR StudentName IN (' + @cols + ')
              ) piv
              ORDER BY BookTitle'

EXEC(@query)