Example Query: You May Try this method:
create table piv (number int primary key,marks decimal(18,2))
insert into piv(number,marks) values (1,24),(2,154),(4,345),(6,234.56),(8,456.90)
select * from piv
select number,AVG(marks) as Average from piv group by number
select 'marks'as number,[1]avv,[2]qq,[4]qq,[6]qq,[8]q from (select * from piv)as sourcetable
pivot(avg(marks) for number in ([1],[2],[3],[4],[5],[6],[7],[8]))as pivottable