get idea from following query
declare @Data
table(Id int,Size varchar(50), QTY varchar(50), AllQTY varchar(50))
insert into @Data values(1, '6.0','8', '2')
insert into @Data values(2, '6.5','2', '3')
insert into @Data values(3, '7.0','0', '0')
insert into @Data values(4, '7.5','9', '5')
insert into @Data values(5, '8.0','9', '2')
select * FROm (SELECT id,AllQTY FROM @Data) src
pivot (max(AllQTY) For id in ([1],[2],[3],[4],[5])) pvt union all
select * FROm (SELECT id,Size FROM @Data) src
pivot (max(Size) For id in ([1],[2],[3],[4],[5])) pvt union all
select * FROm (SELECT id,QTY FROM @Data) src
pivot (max(QTY) For id in ([1],[2],[3],[4],[5])) pvt
