Transpose rows into columns in SQL without using aggregate functions, Sql Server

Language: Layout:

create table MyDataTable (
    RollNo varchar(8)
  , QuesBlock int
  , RespVal varchar(2)
);
insert into MyDataTable (RollNo, QuesBlock, RespVal)
values ('mba0001', 1, 'A'), ('mba0001', 2, 'B'), ('mba0001', 3, 'D'),
       ('mba0002', 1, 'C'), ('mba0002', 2, 'A'), ('mba0002', 3, 'B'),
       ('mba0003', 1, 'B'), ('mba0003', 2, 'C'), ('mba0003', 3, 'A');
/* ---------------------------------------------------------------- */
select
    RollNo
  , Q1 = max(case when QuesBlock = 1 then RespVal else null end)
  , Q2 = max(case when QuesBlock = 2 then RespVal else null end)
  , Q3 = max(case when QuesBlock = 3 then RespVal else null end)
from MyDataTable
group by RollNo;
/* ---------------------------------------------------------------- */
select
    RollNo
  , Q1
  , Q2
  , Q3
from (select RollNo, QuesBlock='Q'+convert(varchar(2),QuesBlock), RespVal
      from MyDataTable) as i
 pivot (max(RespVal) for QuesBlock in (Q1,Q2,Q3)) as p;
/* ---------------------------------------------------------------- */ 
declare @query nvarchar(max);
declare @cols nvarchar(max);

select @cols = stuff((select ','+quotename('Q'+convert(varchar(2),QuesBlock))
         from MyDataTable as C
         group by c.QuesBlock
         order by c.QuesBlock
         for xml path('')), 1, 1, '');
set @query 
  = 'select RollNo, '+@cols+'
      from(select RollNo, QuesBlock=''Q''+convert(varchar(2),QuesBlock), RespVal
        from MyDataTable) as i
      pivot
      (
        max(RespVal)
        for QuesBlock in ('+@cols+')
      ) p';

exec sp_executesql @query;

View schema
Execution time: 0,03 sec, rows selected: 11, rows affected: 9, absolute service time: 0,19 sec