The data you have is insufficient for transforming the rows to columns. One big question is, why Ball is before Cat or Apple. If you would have some kind of ordering column then this could be done. For example a third column describing an ordinal within the value in first column (35 or 26).
For example consider following scenario
create table t2 (
col1 int,
col2 varchar(200),
col3 int
);
insert into t2 values (35 ,'Ball' ,2);
insert into t2 values (35 ,'Cat' ,1);
insert into t2 values (35 ,'Apple' ,4);
insert into t2 values (35 ,'Dog' ,3);
insert into t2 values (36 ,'Cricket' ,1);
insert into t2 values (36 ,'Football' ,4);
insert into t2 values (36 ,'Hockey' ,2);
select a.col1,
(select col2 from t2 b where b.col1 = a.col1 and b.col3 = 1) AS C1,
(select col2 from t2 b where b.col1 = a.col1 and b.col3 = 2) AS C2,
(select col2 from t2 b where b.col1 = a.col1 and b.col3 = 3) AS C3,
(select col2 from t2 b where b.col1 = a.col1 and b.col3 = 4) AS C4
from (select distinct col1
from t2) a
The result for the select would be:
col1 C1 C2 C3 C4
---- ------- ------ ---- -------
35 Cat Ball Dog Apple
36 Cricket Hockey NULL Football