Select query---Show table rows in columns

Why do you need this type of output?

One of the methods is

declare @t table(data char(1))            
insert into @t            
select char(number) as data from master..spt_values             
where type='p' and number between 97 and 104            
            
            
select [1],[2],[3] from            
(            
select row_number() over (partition by number order by data) as sno, * from             
    (            
    select data,ntile(3)over(order by data) as number from @t            
    ) as t            
) as y            
pivot            
(            
    max(data) for sno in ([1],[2],[3])            
) d